Guy,

Maybe you should post some code, because it works perfectly for me. Here's my test code:

create table #test (myint int identity)

insert into #test default values
insert into #test default values
insert into #test default values

select 'Test' + CAST(MyInt AS CHAR(1)) as MyField FROM #Test

drop table #test

The result is:

MyField 
------- 
Test1
Test2
Test3

>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