Hi,
I have a VB6 program that uses ADO (2.5) and Access 97 DB
When I do an SQL SELECt using LIKE it works most times, but not when the text being queried is hard left in the DB record.
EG say I was searching for averly which occurs in the word Waverly.
If that word is in a record such as Mount Waverly, it gets a 'hit'
If that word was on the extreme left such as Waverly Gardens, it does not return a 'hit'
This is the query that was executing -
VB Code:
  1. SELECT * FROM LeadsJobs  WHERE  JobNu<>0 AND  CdJobAddress LIKE '%averly%'
Both the examples I mention above are present in the DB, but only the Mount Waverly record is returned.

Is this a bug, or an incompetent programmer ?

Would appreciate comments