I'm learning SQL Server 2008 syntax and don't know how to translate something that's easy to do in the Fox:
select padr(alltrim(str(integerfield))+characterfield,10) as somefield
I've found the fox.wikis.com article here:
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFPbut still can't figure it out.
Thanks in advance.
Brandon Harker
Sebae Data Solutions