Search for a specific letter

[tomed]

I have a field that contains an alpha-numeric value that I want to search. I need to search the entire field for the letter Q. Then if it is found I will print that record to the report.

Does anyone know of a good way to do this? I know I could do it in a loop, but I figured someone out there might know a more efficient way.

 

[dgillz]

In your record selection formula, use the following:

Instr({fieldname},"Q&quot>0 Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com