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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

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

Message

From

14/06/2001 13:38:26

Michael Levy
Cincinnati, Ohio, United States

To

13/06/2001 12:23:27

John Niemiec
Clark County
Washington, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

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

Miscellaneous

Thread ID:

00518637

Message ID:

00519539

Views:

15

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