the format in sql word "like"

I want to make a key word searching.
Firstly,I try to use the sql word "like",but can't get the correct format for the word,because I used a string variable,how can I write the correct format to fulfill this requirement?Or someone else can suggest me a better way to do this?pls be quick,for I am in a hurry to complete the task.Thanks in advance.
buddha68Asked:
Who is Participating?
 
MarineConnect With a Mentor Commented:
like condition can be expressed like this.
sSQL = "SELECT * FROM TableName where FieldName Like '%Name%'"
this would work
or if you need it to read it from a text box something like this will do
sSQL = "SELECT * FROM TableName where Name LIKE %'" & Text1.Text & "'%"

OR
LIKE '%" & Text1.Text & "%'
0
 
paulstampCommented:
Not entirely sure what you mean -are you talking about in a DB or with variables.

If using variables... use INSTR(SourceString, Match), ie

in instr(Target, "ThisString") <> 0 then msgbox "Found 'ThisString' in " & target

instr returns the position within the first string or the second string or 0 if there is no match, ie will return 2 if you do instr("band, "and")

Hope thats what you mean.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.