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?