* in LIKE clause

 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
LVL 1
mativareAsked:
Who is Participating?
 
MarineCommented:
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
 
woottondCommented:
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
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.