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

Try something like

select cast(cast(IntegerField) as varchar(10) + characterfield) as char(10)) as NewField

You may also check CONVERT() function.


>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.