You guys rock.

Thanks - i think all of your versions would probably work but ended up using this:

select

t.AuthorId,t.

Thank you all very much - I will try to implement these revisions and report back. Much appreciated.

Danielle

actually looking at your comment - now I think I understand your question better ...you mean performance wise - it would be better to concatenate the string in the C#...

thanks for the examples!!

the answer about concatenating - is that the query populates a dropdown list UI element - and thus must be a single column presentation

Am I missing something? I don't see anything in this code that does the check I am looking for and adds "(empty)" string to every Fund name that has no...

i have looked at the built in stuff.

i'd be interested in anyone's ideas about 3rd party tools.

bumpty bump

Thanks much - works perfectly.

Thanks - do you know what the pricing is for Client Access Express - and where to find the download.

THX,

d

Thanks - do you know what the pricing is for Client Access Express - and where to find the download.

THX,

d