MS Access: searching a column for a star/asterisk

Question

I'm looking for a way to search a column of string datatype which contains a * - the problem is that the star or asterisk is a reserved symbol. The following query doesn't work properly:

select * from users where instr(pattern,"*")

How can you write an Access query to search a column for an asterisk?

Answer 1

You can search for reseverd charaters in Access by using square brackets:

select * from users where pattern like "*[*]*"

Answer 2

yay, found it out by myself:

select * from users where instr(pattern,chr(42))