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?
Liam O'Hagan
MCP VFP Desktop Apps