How about creating a view with the distinct clause and then doing a count(*) on the view.
Narayan
Attachments
Library
Quick Reference
Archives
Sample Index
2005 Indexes