Use LIKE in SQL satement

[chairyuan]

My DB is Access 2000.

If I have my SQL string

as SELECT * FROM CUSTMST

or SELECT * FROM CUSTMST WHERE CUSTID = "ABCD"

My program all return the right result.

 

But if I use

SELECT * FROM CUSTMST WHERE CUSTID LIKE "AB*"

There is nothing returned.

Why that happen? I tried the same SQL in Access itself, the result is fine.

 

Help, please. Thanks

[bizzydint]

Cant see a reason for it, other than there's something wrong with your code containing the SQL string.....

 

what are you using?

[chairyuan]

I found it.

We should use % instead of * in VB SQLstatement.

So if I change my select to:

SELECT * FROM CUSTMST WHERE CUSTID LIKE "AB%"

it works.

[wyrd]

Access and SQL Server are a bit different. Access uses % and SQL Server uses *

[PlausiblyDamp]

SQL Server uses %

Not sure about Access though....

[techmanbd]

I used "*" in access and I get a result.

SELECT * FROM tblArtist WHERE Artist_Name LIKE 'So*';

And I get

Social Distortion

So why your,s doesn't work, don't know.

 

Maybe you should throw up your code so we all can see. Maybe something in there.

[techmanbd]

never mind, I see you found it, didnt read that part