Filtering out fields with asterisks in MS Query

Does anyone know how to filter out fields contains multiple "*" using Microsoft Query?

I am running a query on my database and trying to filter out a field which contains varying amount of asterisks.

I cannot get it to work.

Tried Contains '*'

Tried Like '[!*]%'

Tried begins with '*'

is an asterisk a wildcard in sql? and if so, is there a character like the tilde I can use to ignore the wildcard and search the actual character?

btw, i did try using the tilde to no further avail.

I can't test myself but wonder if contains[*] may work ?

Hi DonkeyOte,

It converts that to:

Not Like '%[*]%'

and it doesn't work..

I am trying to filter those out... so "does not contain the asterisks" is what I need.

I think i got it...

I tried does not end with '*'

ie. Not Like '%*'

and it worked....

I guess it doesn't allow the asterisk to be first char... but okay if it is mid or last

I did a test against an XL file with does not contain[*] and it returned the expected results...

Not sure why it didn't work with my data then.. it should have, if does not end with worked... strange...