Home / Software / Tips and Tricks / How can I create a string by concatenating a column from a table without using a cursor?

How can I create a string by concatenating a column from a table without using a cursor?

Updated:  07/01/2010 14:07 PM
Author:  Shiju Mathews

Status:    Resolved.


Consider a table Employee which contains a field called ‘EmailAddress’. For emailing a matter to a particular employee we need all email address separated by ‘;’( semi column).