Searching a Database

[passagewds]

Does anyone know what the best way is to have a query run to pull records out based on finding one letter in a field.

In other words, I am storing a list of letters based on form input. Example could be 'bdfg' and I want to find a way to have the query check the record to see if that field contains the d.

I hope that makes sense to someone.

Mike

[cgraz]

SELECT * FROM yourtable WHERE field LIKE ' %bdfg%'

Cgraz

[passagewds]

The %a% worked great,

Just one other thing... what would cause a search to NOT read the first record? the search is

"SELECT * FROM orgs WHERE dance LIKE '%e%'";

[cgraz]

I don't know why it wouldn't read the first record. What is in the first record and what results are being outputted?