CODEWITHSUNDEEP
sqlms-access-2010
Cauan KMS
Cauan KMS

Reputation: 33

Access/SQL - My LIKE sentence is not working, and I desperately need to know why

SELECT cod
     , item
     , sn
     , num
FROM Product p
INNER JOIN Zol z
   ON p.[num] = z.[item]
where p.num like "50-%"

Of course it was for testing purposes, so the only answer should be "50-56", but it's not returning me any results :/

Upvotes: 2

Views: 45

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271003

The wildcard for MS Access in a LIKE is the non-standard *. So, try this:

SELECT cod, item, sn, num
FROM Product p INNER JOIN
     Zol z
     ON p.[num] = z.[item] 
WHERE p.num like "50-*"

Upvotes: 4

Related Questions