Evan,
Take a look at Message #
997657 >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