What in TSQL is comparable to padl() function in VFP? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What in TSQL is comparable to padl() function in VFP?

Message

De

14/06/2001 13:38:26

Michael Levy
Cincinnati, Ohio, États-Unis

À

13/06/2001 12:23:27

John Niemiec
Clark County
Washington, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: What in TSQL is comparable to padl() function in VFP?

Divers

Thread ID:

00518637

Message ID:

00519539

Vues:

16

You can simplify this:

SET @nextjobid = RIGHT(REPLICATE('0', 5) + LTRIM(RTRIM(@nextjobid)),5)

-Mike

Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com

Click here to load this message in the networking platform