How to combine 3 email id with comma ; separate d in SQL ser

declare @tblemail table (EmailID1 varchar(64),EmailID2 varchar(64),EmailID3 varchar(64),empname varchar(64))

insert into @tblemail values ('[email protected]','[email protected]','[email protected]','jayesh')

select empname, isnull(EmailID1,'') + ';' + isnull(EmailID2,'') + ';'+ isnull(EmailID3,'') as mail from @tblemail

hi,

try below code

 

Try following: 

Just a side note, having 3 email columns in one table is not quite a good design decision. In cases such as these, it is recommeded that you have separate table with just two columns employeeCode and email and have as many rows as business needs to save email addresses.

May be you should provide some sample data. Is the data currently in 3 different columns in the same row? Or in one column in 3 different rows? 

 

Please provide sample data in plain text format, so that it can be used to provide you the script. If you give screen-shot we cannot use data from it.

 

Hope you understand.