I am trying to run a query that searches records that contain an "*". Not a good choice to search for I know as obviously inputting Like "*" brings back all records. Does anyone know how I can acheive this?

Basically the field I am querying contains alpha and numerical characters, but some have a * - which are the records I want to pull out or omit. The records are not at a consistant length unfortunatley.

Ok, sorry I should have searched the board properly.

The answer was to put the * in square brackets. so I just entered Like "* *".