You're welcome.

>Thank you.
>
>>It's better to avoid UDFs in the queries for performance reason. In most cases following should suffice

>>-- PADR(col1, 25)
>>CAST(col1 AS char(25))
>>-- PADL(col1, 25)
>>REPLICATE(SPACE(1), 25 - DATALENGTH(col1)) + col1
>>

>>
>>
>>>Is there a SQL Server equivalent for the FoxPro PADR() and PADL() functions. These function pad a string either to the left or right up to a specified number of characters. In this case I'm only concerned with padding with spaces.
>>>
>>>BTW, thanks to those building this page
>>>http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping