Solved

* in LIKE clause

Posted on 2000-02-25
2
132 Views
Last Modified: 2010-05-02
 WHERE [Name] LIKE 'S*'   works in my Access 2000 database
in VB6 + ADO 2.1 it returns empty recordset, but if I modifie SQL to
WHERE [Name] LIKE 'SecurID' it works fine
what is the issue with * over here
Sincerely,
Matt
0
Comment
Question by:mativare
2 Comments
 
LVL 6

Accepted Solution

by:
Marine earned 50 total points
ID: 2559080
when placing a * it should search all records beging with S its like a wild charecter, try placing the %% sometimes. something like this
LIKE '%S%'
0
 

Expert Comment

by:woottond
ID: 2559629
I agree % is the db wild card of choice
* is used less frequently - and "Thats my final answer Regis"
;)
ché
wootton

(sorry - it had to be said)
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

757 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

16 Experts available now in Live!

Get 1:1 Help Now