• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

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.
1 Solution
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.
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 & "'%"

LIKE '%" & Text1.Text & "%'
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now