I have the DECLARE further up the code and do NOTHING to it until here, I am trying to create a list of ID's, during the WHILE loop.
I can PRINT @SID and I get a nice set of data; however when I PRINT @NewRecordIDList I get nothing...I can not even get HELLO to print in the following PRINT 'HELLO' + @NewRecordIDList; but if I remove the + @NewRecordIDList it prints HELLO fine. Baffled Brad -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:26 AM To: SQL Subject: RE: Concatenation assistance... erm... have you tried : DECLARE @FOO VARCHAR(3) SET @FOO = @NewRecordIDList + ',' + CAST(@SID AS VARCHAR(25)) PRINT @FOO -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: 05 September 2003 12:07 To: SQL Subject: Concatenation assistance... Why doesn't this output anything? I know that the @SID has a AT least 1 value??? ... WHILE (@@FETCH_STATUS = 0) BEGIN PRINT @SID -- appendIDTo @NewRecordIDList SET @NewRecordIDList = @NewRecordIDList + ',' + CAST(@SID AS VARCHAR(25)) END ... Thanks Brad [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Get the mailserver that powers this list at http://www.coolfusion.com
