Oops, should have said... the 20 is just a value I picked. Use your own.

L



>Hi Michael,
>
>Something like this?
>

Select IsNull(Replicate(' ', 20 - len(SomeField))) + SomeField as SomeName from SomeTable

>
>Regards,
>
>Liam
>
>
>
>>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?