I need to search surname, firstname, company name, in that order from a database and then display the results, with no duplicates. The database is small at the moment, so i can do three queries and then list the results in order. i.e. query 1 results, then query two results. So how do I do this efficiently, pref. using only one query. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.