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?