i have a problem i have a database where i have 100,000 records. i want to be a ble to query one field in the table. i only want to see the data in that field that is original from anyother data in the field. for instance if the word "bend" is in the field 5,000 times i only want to see it once in my query. any ideas.

Use 'DISTINCT' clause. Search for help on this and you will find plenty of examples on it.

SELECT DISTINCT(myfld) FROM
myTable ;