Query of Oracle to SQL Server

[Muhammad Saifuddin]

SELECT firstName || ' ' || lastName from usertable;

How to do it in SQL Server?

[Muhammad Saifuddin]

No problems. Solved it. Found it in SQL Server Help.

The query in SQL Server would be

select { fn CONCAT( firstName ,{ fn CONCAT (' ', lastName)})} from usertable

if any one have a short solution for that so please share with me..

thanks
[ August 04, 2006: Message edited by: saif uddin ]

[Scott Johnson]

  
 
select firstName + ' ' + lastName from usertable