Is it possible to create a select statement that grabs the data out of two columns and returns that data as a single column? I.E Select Column1 + Column2 AS CombindedColumn form dbo.Table?
-- If I get used to envying others... Those things about my self I pride will slowly fade away. -Stellvia
make sure you add check for NULLs and convert them to blanks or some default value if any of columns are nullable. Otherwise the concatenation causes result to be NULL if any of columns have NULL values under default conditions
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
How to display two columns as one
Posted - 05/23/2012 : 17:39:09
