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 17:47:02
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00518637
Message ID:
00519748
Views:
14
I love this place. Always a better way to skin a cat and throw ideas around.

Thanks
John

>You can simplify this:
>
>SET @nextjobid = RIGHT(REPLICATE('0', 5) + LTRIM(RTRIM(@nextjobid)),5)
>
>-Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform