you can create this view (and modify to add more infromation) in the model database and user databases and then query the view. Works well for searching information...

Thanks!

Heres what I ended up with before I say your reply.

, IsNull(dbo.drug_eligibility.UpdateDate, CreateDate) AS SortDate

its working. Thnaks again!