Solved: Searching for a text string in an Access Database

[AndyClay]

I am using Query Design to set up a new query.

I have one field that contains a surname. I need a formula that returns TRUE (or a value) when the surname contains "DECEASED" and FALSE (or an error) when the surname doesn't.

The Worksheet function SEARCH doesn't seem to work. Any ideas?

[Norie]

Take a look at the Instr function.

Deceased: IIf(InStr([SurName],"DECEASED")<>0,"True","False")

[AndyClay]

This works perfectly. Thanks very much.