PADL() equivalent in SQL Server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

PADL() equivalent in SQL Server

Message

10/04/2003 10:30:55

10/04/2003 10:26:00

Liam O'Hagan
O'Hagan Programming Ltd
Irlande

Information générale

Forum:

Visual FoxPro

Catégorie:

Client/serveur

Titre:

Divers

Thread ID:

00776019

Message ID:

00776050

Vues:

>Left out the second arg for IsNull()...
>
>

SELECT IsNull(Replicate(' ',20-len(STR(MONTH(AddDate)))),'')+STR(MONTH(AddDate)) FROM News

This doesn't work either:

SELECT ISNULL(REPLICATE('0',2-LEN(STR(MONTH(AddDate)))),'')+STR(MONTH(AddDate)) FROM News