M
Mark
Hello all,
I am having trouble using an SQL statement in vb, where the Where clause is
Like and wild cards on both ends.
I have tried many different syntax, but nothing seems to work.
Here are some things I have tried
vCriteria = “*†& txLkUp & “*†‘Using this to add the wildcard
vSQL = “Select * from tb where fld like vCriteria
vCriteria = txLkUp
vSQL = “Select * from tb where fld like “*†& vCriteria & “*â€
vCriteria = txLkUp
vSQL = “Select * from tb where fld like vCriteria
The list could go on and on, but apparently not to the right way. Can
someone shed some light on this? Also, the field is a text field.
Thanks
I am having trouble using an SQL statement in vb, where the Where clause is
Like and wild cards on both ends.
I have tried many different syntax, but nothing seems to work.
Here are some things I have tried
vCriteria = “*†& txLkUp & “*†‘Using this to add the wildcard
vSQL = “Select * from tb where fld like vCriteria
vCriteria = txLkUp
vSQL = “Select * from tb where fld like “*†& vCriteria & “*â€
vCriteria = txLkUp
vSQL = “Select * from tb where fld like vCriteria
The list could go on and on, but apparently not to the right way. Can
someone shed some light on this? Also, the field is a text field.
Thanks