I know that you already got a lot of answers but I'll throw in another one
SELECT RIGHT(REPLICATE(' ', 20) + expr, 20)
-Mike
>From a SQLExec(), I need to have calculated field based on a PADL() VFP equivalent. However, that function doesn't exist in SQL Server. What can I use?