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]
