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