Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Padding Strings
Message
From
08/01/2007 13:40:55
Sergey Berezniker
New York, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Padding Strings
Miscellaneous
Thread ID:
01183507
Message ID:
01183521
Views:
15
>How can I pad strings like the VFP PADL() and PADR() command in SQL?
-- PADR with spaces
CAST(oldvalue, CHAR(<NewLength>))
-- PADL with spaces
RIGHT(REPLICATE(SPACE(1),<NewLength>) + oldvalue,<NewLength>)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform