Can return it to ASP, VB or Access front ends. Wanted to construct the query in SQL but XML idea looks really good. Only looking to return rows for 1...

Good call and sure I will use this at some point. Problem is I am not sure how many columns I need to return before I run the query and...

Cheers. He seems to have done the same thing as me but in a longwinded fashion. Will stick to my method.

If you want to know what I am doing let...

Sounds like good idea.

If you could that would be great cheers.

Thought this was probably the case - definitely messy!

Have to reference alot of tables for this as basically want to find all member data across DB. Have set up a...

Is this just not possible????????

At the moment I am using a temp table to store column names and values. It would be ideal if I could use some sort of...

I only want to return columns that have values for a member, isnull will still return an actual column and heading.

e.g.

select ColX, COlY from table

if COlX is null and...