help for to search a word in a field

Can you help me to provide command to search a word using input in a
Text field with SQL section. I know there is a command "LIKE" but I
could not get output correctly by applying those.
TEXT1.TEXT = "KUMAR"
rs.open ("SELCT * FROM CUSTOMER WHERE CUSTOMER.NAME
LIKE "TEXT1.TEXT"; "

THE output should be to get all the names contain KUMAR anywhere in a
field.

So please help me with samples programme and it will he highly
appreciated.

Thanks & Regards

Suresh

Messages in this topic (1) Reply (via web post) | Start a new topic

.

SELCT is mispelled
You probably need a wild card (% or * depending on what you are using
and where)

It is cleaner to do this
Dim sSQL as string
Dim sFind as string
Assuming that user is entering data into Text1, do this
sFind = Text1.Text
sSQL = "SELECT * FROM CUSTOMER WHERE CUSTOMER.NAME LIKE " & "%" &
sFind & "%"
Debug.Print sSQL 'So you can see what it looks like, if you have
problem.
Then use sSQL in your .Open

Regards,
Rob

Messages in this topic (2) Reply (via web post) | Start a new topic

.