Solved

the format in sql word "like"

Posted on 2000-02-19
2
128 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:buddha68
2 Comments
 
LVL 3

Expert Comment

by:paulstamp
ID: 2538377
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
 
LVL 6

Accepted Solution

by:
Marine earned 50 total points
ID: 2538384
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

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now