Tuesday, July 30, 2013

Select multiple column into a single column

Try this

SELECT isnull(col1,'') + isnull(col2 ,'')+ isnull(col3,'') as newCol  FROM Tablename




Satheesh


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)