combine two fields 1

[saintedmunds]

Hi

I have a table with 3 fields ContactID Email Email2

I would like to get an SP to return the following

ContactID Email
23 me@me.com;you@you.com

but if they dont have a second email then just return

ContactID Email
47 xx@xx.com

I'm really not sure how to achieve this so any help would be great.

Cheers

 

[bborissov]

SELECT ContactId,
       eMail+CASE WHEN ISNULL(eMail2,'') = ''
                       THEN ''
                  ELSE ';'+eMail2 END AS Email
FROM YourTable

not tested

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[saintedmunds]

Works great thank you