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~VFP


but still can't figure it out.


Thanks in advance.