Have a look at the BOL entry for what it's use is, "Returns the first nonnull expression among its arguments.".
-----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT ValueList() in T-SQL that could be incredibly useful.... > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:48 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > I've never used it in this manor before, but here's a quick example... > > > CREATE TABLE #temp ( Email VARCHAR(100) ) > > INSERT INTO #temp ( Email ) VALUES ( "email1" ) > INSERT INTO #temp ( Email ) VALUES ( "email2" ) > INSERT INTO #temp ( Email ) VALUES ( "email3" ) > INSERT INTO #temp ( Email ) VALUES ( "email4" ) > INSERT INTO #temp ( Email ) VALUES ( "email5" ) > INSERT INTO #temp ( Email ) VALUES ( "email6" ) > > SELECT * FROM #temp > > DECLARE @emails varchar(200) > > SELECT @emails = COALESCE(@emails + ', ', '') + CAST(Email AS > VARCHAR(5)) FROM #temp > > SELECT @emails > > -- DROP TABLE #temp > > > Nice :O) > > Ade > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:38 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > ooo - that's nice. > > > -----Original Message----- > > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > > Sent: 24 October 2003 15:37 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > > > > Scroll to the bottom... > > > > http://www.sqlteam.com/item.asp?ItemID=2368 > > > > Ade > > > > -----Original Message----- > > From: Justin [mailto:[EMAIL PROTECTED] > > Sent: 24 October 2003 15:33 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > > > > > You could use COALESCE to build a valid list. > > > If your on mssql. > > > > I am. Version 7. > > > > Not sure how to that? If I have > > > > Email > > ------------- > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > How do I get > > > > [EMAIL PROTECTED],[EMAIL PROTECTED] > > > > SELECT EMail From Table > > > > Thanks > > > > > > -----Original Message----- > > From: Paul Fennell [mailto:[EMAIL PROTECTED] > > Sent: 24 October 2003 15:14 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > > > > > > > > -----Original Message----- > > From: Justin MacCarthy [mailto:[EMAIL PROTECTED] > > Sent: 24 October 2003 15:14 > > To: Cfuk > > Subject: [ cf-dev ] OT ValueList() in T-SQL > > > > > > Hi all, > > > > Anyone know of T-SQL to do the same as ValueList() ??? > > Am I stuck with a cursor? > > > > Thanks Justin > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
