[Solved] Need to combine two columns in a table [closed]

by


IN Sql server 2010,2012 use CONCAT(firstname , ‘ , ‘ , lastname )

2008 and lower version just use as

select firstname + ” + lastname as fullname from users.

if you alias name then

select fn+ ‘ ‘ + ln as fullname from (
select firstname as fn, lastname as ln, userid from users )

solved Need to combine two columns in a table [closed]