>How can I pad strings like the VFP PADL() and PADR() command in SQL?
>
>Thanks
If you don't want to use functions:

--- PADL
SELECT RIGHT(REPLICATE(desired char here, length of the padded string)+SomeString, length of the padded strng)
-- i.e in VFP: PADL([MyString],20,[0])
SELECT RIGHT(REPLICATE('0', 20)+'MyString', 20)
-- Result -> '000000000000MyString'


--- PADR
SELECT LEFT(SomeString+REPLICATE(desired char here, length of the padded string), length of the padded strng)
-- i.e in VFP: PADR([MyString],20,[0])
SELECT LEFT('MyString'+REPLICATE('0', 20), 20)
-- Result -> 'MyString000000000000'