Search in a string

[S1naps1s]

Is there a way that I can search for certain characters in a string?
Basically, if a DLookup returns "January Holiday", "February Holiday", etc...


If it contains the word "Holiday" I want it to display in a form field as "H"
To me it would be similar to using "* Holiday" in a windows search. How would I go about doing this?

Thanks in advance!

[June7]

Maybe use an IIf() expression:

IIf([field or textbox] Like "*Holiday*", "H", "something else")