Query with SQL statement to return Unique records

[HebieBug]

Am creating a connection to an SQL 2000 database.
The reordset is generated with a SQL string.
When I was working with Access forms notied their was an option to display only unique records.
If I had a field with called Example and the records inside where:
John
John
Peter
Peter
Paul
HebieBug
Then the reordset would contain:
John
Peter
Paul
HebieBug
Is there a way of adding to the SQL string a command that will omit duplicate records?

 

[Guest_imported]

Yes,

If you use the word 'DISTINCT' in the sql query, the duplication is omitted. For example:

SELECT DISTINCT * FROM TABLENAME WHERE ....

ok

 

[tyant]

The sql statement should look like:

sql = SELECT DISTINCT FirstName FROM TableName