When is a Wildcard not a wildcard?

[Rusty]

Hello,

I am trying to run a query to pick up some odd entries in a rather large database.

Users have been keying data into a text field such as "Nationally funded?" and "Nationally funded / Local Charity"

I need to search for all these 'odd' entries and can't use the criteria:
Like "*?*"

because ? is a wildcard and so all the records from that table are 'found'.

Does anyone know how to search for a character like a ? in a query?

Many thanks,

Rusty

 

[WayneRyan]

Rusty,

Like "*[?]*"

Wayne

 

[Rusty]

That's spot on and worked a treat - thanks Wayne

 

[gemma-the-husky]

that sort of thing is why you dont let users type random stuff in important fields

you give them a combo box (drop down) with the values you want them to select from

 

[Rusty]

Yep that's exactly what I told my boss when he asked for the field in question to be an updateable drop down list.

I'd much rather it was a straightforward combo box with a range of pre-set values to select for the very reason that I am now tidying it all up.

That's the problem when users get free rein to enter data ... no matter how many times you tell them how to do it properly they mess up

It's no biggie and apart from that the database is running very well

Tally ho!

Rusty