[Resolved] Taking a text string and converting it into a search string

[edwardp]

I want to take a text string from a textbox and use it to search a database ie:

USER INPUT: (a + b) OR "cat"

and convert into

SQL : ((PART.DESCRIPTION like '%a%' AND PART.DESCRIPTION like '%b%') or PART.DESCRIPTION like '%cat%')

Does anybody know any routines that does this sort of thing?

cheers

[saraadmin]

There are existing functions to do this, but that doesn't stop you rolling your own!

One thing you might want to consider is having a more strict user input query format:

(("a" AND "b") OR "cat")

because it'll make parsing it easier.