Did you initialize your @NewRecordIDList = '' first? If not, then it's null, and null + varchar = null.
-----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 06:10 To: SQL Subject: RE: Concatenation assistance... Correction...it DOES display the @SID for the PRINT statement, however after the END I have this: PRINT 'TEST' PRINT 'HELLO' + LTRIM(@NewRecordIDList) This displays the following: TEST That is it, why doesnt the @NewRecordIDList get displayed? Brad -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:07 AM 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
