Hi, a newbie question. I have columns (ID, Name, Surname and Date). i want to make query where I get 3 columns (Name and Surname merged). I know I can do
SELECT Name + ' ' + Surname as Fullname, however I cannot figure neither google out how to still display the ID and Date columns. Please, help. Thank You. i have MSSQL
SELECT Name + ' ' + Surname as Fullname, ID, Date
FROM <your_table_name_goes_here>
1 Like