At 11:02 PM 12/04/2007, you wrote:

>We're looking to get all fields for the records that match the criteria.

Hmm, so if you want to eliminate records in which col1, col2 is
repeated, how do you decide which is the one you want the "other"
details for? Oldest? most recent? the one with the biggest (or
smallest) something-or-other??????

The requirement just aint logical...

./hb