Hi,

In VFP I can combine/convert data types within a select statement like so:

 SELECT "test" + ALLTRIM(STR(myintegerfield)) AS MyField ;
 FROM mytable

If I have three rows and the values of myintegerfield were 1,2,& 3 respectively, the results would be:
test1
test2
test3


In TRANSACT-SQL I have tried CAST and CONVERT to accomplish the same thing but the results always come back as:
test1
test1
test1

SQL Server (7.0) is only converting the numeric field once instead of for each row like VFP does.

How can I make this work in SQL Server?

Thanks,
Guy