We have an application for our help desk people internal. They want to have it modified to provide a better search solutions. I already talked to them about Regular Expressions and they didn't care for that. They wanted something on how some of the internet searches work. For Example they want to enter

(video or display) and blinking

I looked at the NORMALIZE function in foxpro which returns

(VIDEO.OR.DISPLAY).AND.BLINKING

Since we only have one field that needs to be checked all I would need to change is something like

(ATC('VIDEO', problem)>0.OR.ATC('DISPLAY', problem)>0).AND.ATC('BLINKING',problem)>0

It started to look easy but it's more work than I initaly thinking. Before I take too much time is there something else I could use. API? Website? that would help in converting these types of querys into Foxpro commands.