>thats where I was going at first but I sometime I just need to ping on you guy's.
>I can have some fun doing it in some adhoc array looping code or whatever
>I just did not want to have to do it if there was a 1 liner of SQL
>thanks.
I guess there ain't no one-liner - or few-liner for that matter - mainly because of the possibility of duplicate fields. Otherwise the task would be quite simple.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)