>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.
If it's not broken, fix it until it is.
My Blog