sql concatenate columns
snippet in sql

sql concatenate columns

user1596


  SELECT CONCAT(Address, " ", PostalCode, " ", City) AS Address
FROM 
  Customers; 

mysql concat and use as where column

user5587

select * from table where concat_ws(' ',first_name,last_name) 
like '%$search_term%';

concat two columns in sql server

user5338

select Convert(nvarchar(50),ID)+'-'+Convert(nvarchar(50),Year) as ID_Year from tablename