1234,Camping Site A
3239,Camping  Site B
3043,Camping Site C
1234,Camping Si                        'intentionally typed

I only want returned:
1234,Camping Site A
3239,Camping  Site B
3043,Camping Site C

1234,Camping Site A

or

1234,Camping Si

?

This will work for the sample data you posted ... whether it will work for
your actual data, I don't know.

create table Roswell
(
 ID int NOT NULL,
 Data varchar (15)
)
go

insert into Roswell values (1234, 'Camping Site A')
insert into Roswell values (3239, 'Camping  Site B')
insert into Roswell values (3043, 'Camping Site C')
insert into Roswell values (1234, 'Camping Si')

select ID, MAX (Data) as Data
from Roswell
group by ID

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Thanks to the fact that you did not post any DDL, we have no idea what "id" is identifying, or even if it is an identifer at all, or even the name of this table!  If it was an identifier, then it would be either a PRIMARY KEY or NOT NULL UNIQUE in the DDL and you could not insert the duplicate key.

If you are working from specs this bad for money, update your resume and find a better job.  

--CELKO--

SQL guru at Trilogy
===========================
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, datatypes, etc. in your schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!