Is there a way to display all the results of a row as one big comma delimited string?
ie.
select * & ","
from mytable
results
3,my house, wife, 8
IOW, I dont want to have to know the column names of mytable. I just want one big comma delimited result for each row.
While Im pretty sure we are venturing outside standard SQL, I would like to keep it as close as possible.
Thanks
Chad