Why doesn't SQL LIKE work in Microsoft Access?

Posted by poo on Stack Overflow See other posts from Stack Overflow or by poo
Published on 2010-04-01T07:11:46Z Indexed on 2010/04/01 14:53 UTC
Read the original article Hit count: 217

Filed under:

I want to my make a search-statement and query things like this

select * from table where col like '%vkvk%' 

But with trial and error I've come to the conclusion that access doesn't work with LIKE or wildcard operators. Does anybody have some other solutions because I ain't so in to access actually, so I really don't know.

© Stack Overflow or respective owner

Related posts about ms-access