DECLARE @NameList VARCHAR(255)
SELECT @NameList = COALESCE(@NameList + ',', '') + Name
FROM tblName
PRINT @NameList

thanks - didn't realize you were a "regular" - it's good to hear from those who attended and first-hand accounts are always welcome!

Well - results in text (as Chris explained above) should allow you to see all the results...is that not what you're asking for ?!

Just a comment to all those who complained that this article should not've been named - "Best kept secret" - or that it should not have been published at all...There's...

you forgot to say - "in my unique, kind and gentle way"..

so bottom line - was it worth it or not - was it good as a one-time experience or have you now become a PASS-addict ?!

don't mind me david - was just having some fun before I sally forth into my internal office and become a workable deptworker...

where remi...

Did you meet any of the SSC people ?!?! what about the presentations - attend those by Adam Machanic, Ken Henderson, J.C etc... ?!?!

"edit again, still not right, will not work forgot about internaloffice problem.."

far as I can tell the only thing wrong with "internal office" is "unworkable deptworker"..

stop taunting remi - it's not nice and it's not nice...and did I mention...IT'S NOT NICE!!!...

not to "take away" from this scintillating exchange of yellow walls and cheap shots and screenshots etc...but alzdba - you have set me on a completely different trail today -...

this is my take...making an "is null" comparison is more of a pain because of all the issues related to nulls than if you were to check, say, for length...

For the most part, most people are averse to change and however badly things may be going, still prefer to stay on with the "known devil" than move on to...

that's funny - 'cos I thought that's what I would get back, but I actually got results that were posts I had participated in!!!

Phil - you could always use the "search" (on the menu bar) to look through the "discussions", "articles" & "scripts" - here're a couple of links it came back with...