A00001 A00002 A00003 A00004 A00005
IBM Infoprint 1312 IBM Infoprint 1222 IBM Infoprint 1226 IBM Infoprint 1226 HP Color Laser Jet 5
A00001-IBM Infoprint 1312 A00002-IBM Infoprint 1222 A00003-IBM Infoprint 1226 A00004-IBM Infoprint 1226 A00005-HP Color Laser Jet 5
CONCAT
+
SELECT CONVERT(NVARCHAR(80), ItemCode + '-' + ItemName) AS NewName FROM YourTable
select ItemCode + '-' + ItemName As col1 from table_name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)