use "select distinct"
such as:
select distinct FName,LName from tbl_Customers

Brian Freeman
Bluwave Computing/Carnegie Technologies
www.bluewave-computing.com / www.carnegie.com
(770) 916-0595 ext. 415


-----Original Message-----
From: Jaimie Freitas [mailto:jaimie.[Email Address Removed] Thursday, April 24, 2003 9:06 AM
To: LazyDBA.com Discussion
Subject: Stupid Question


Hi I need a query that will return all the unique customer names from a
table.

I have a database full of duplicates and only want to the name to appear
once in the query as opposed to 10 times!

Thanks for any help in advance

Kind regards

Jaimie


The contents of this e-mail are strictly confidential and are intended only
for the addressee named above. This e-mail may contain confidential or
privileged information. If you are not the intended recipient of this
message please notify the sender immediately. The contents of this e-mail
must not be disclosed to any other person or copies taken. Please note that
any views expressed in this e-mail may be those of the originator and do not
necessarily reflect those of this organisation. Internet e-mail is not a
secure communications medium. Please note this lack of security when
responding by e-mail. Accordingly we give no warranties or assurances about
the security and content of this e-mail and its attachments. Neither Thermo
Electron Corporation nor the sender accepts any responsibility or liability
for viruses and it is your responsibility to scan the e-mail and
attachments. Any liability arising from any third party acting on any
information contained in this e-mail is hereby excluded. (c) Thermo
Electron Corporation www.thermo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page