Antares, I think you're on the right track but it came up wrong...this is how it came up...

So far so good, thanks Noel!

select a.contactd_id,a.contactd_contactmid,

a.contactd_status,a.contactd_email

from test1 a

where a.contactd_status in (Select max(contactd_status)

   from test1 b

   where b.contactd_contactmid=a.contactd_contactmid)

Figured it out from one of the articles on this site...thank you!

collate Latin1_general_CI_AS

Hey Paul,

This seems to work but how could I use it in a function?

Jeremy,

You're right on LOL I was just returning to say that I figured it out and that was the exact solution I got...thanks though!

Thank you all, these have been a great help