Still need help with the SQL Like statement

I'm still experiencing problems trying to get my SQL statement to run properly. I appreciate all the replies, but I still can't get it to filter data.
I have tried this piece of SQL which works fine.
sql = "Select * from equipment where equipment_no like 'D% "
which as you all know will filter all records starting with the letter D. But what is the correct syntax for placing a variable name or a text box in place of the letter D. Please help, as I'm pulling my hair out.. It must be so simple or maybe I'm so simple.
Please help..
If I can't get this database to work, I'm considering pottery instead.

if you want to use a variable, it is LIKE?

then, use your text box as your variable. if you want to use the wildcard just type whatever you want, like D% in the text box.

hope this helps..
k

i'm not sure what you mean.. are you able to give me an example line of sql code that will show me how i can filter data in a database table. What I have is a simple database with one form with a flexgrid and a text box and a button it is that simple..., all i want to do is allow the user to type any string value in the text box and it will filter the field in the table.
I have tried:
sql = "Select * from equipment where equipment_no like '% " & txtfind & " % " but it doesn't work.
and
sql = "Select * from equipment where equipment_no like '% " & txtfind & " %'"
but this doesn't work.
if you can help, I would very very happy.

try this:

sql = "Select * from equipment where equipment_no like " % " & txtfind & " % "

oops!

sql = Select * from equipment where equipment_no like '% " & txtfind & " % "

OR...this is how I like to do it, less code


create a command in your DataEnvironment. Use SQL Builder to create your query and use LIKE? for your variable in criteria.

then call your command from your form.

like this:

DataEnvironment1.YourCommand txtfind & " % "

i will give it a go..many thanks for your help..much appreciated.