VB6, SQL and the LIKE operator 2

[HaworthBantam]

I am creating a sql string....

MySQL = "SELECT * FROM tblRemissions WHERE CustomerName LIKE '*" & strVariable & "*'" & " ORDER BY RemissionID"

strVariable is as it suggests, is a string variable.

If I use a sql string where the whole name is known....

MySQL = "SELECT * FROM tblRemissions WHERE CustomerName = " & strVariable & " ORDER BY RemissionID"

....it works.

Is any kind soul out there able to point out my mistake ?

Thanks.

 

[MakeItSo]

Perhaps you are using ADO reference instead of DAO.
In that case, the wildcard character is %
If this works:
MySQL = "SELECT * FROM tblRemissions WHERE CustomerName LIKE '%" & strVariable & "%'" & " ORDER BY RemissionID"

Then you have ADO reference...

Cheers,
makeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[johnwm]

SQL wildcard operator is '%' not '*' . Your line should read:
MySQL = "SELECT * FROM tblRemissions WHERE CustomerName LIKE '%" & strVariable & "%'" & " ORDER BY RemissionID"

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[HaworthBantam]

You are both stars - thanks.