Database Software

hi folks,

i'm looking for some help on syntax/formatting for a contains clause that incorporates an exact phrase.

e.g. if the user enters: "blur or massage"

i'd like to run the search for the exact phrase rather than in boolean context. any tips? is there some way to set off an exact phrase within the contains clause? the docs aren't too helpful when they state that multiple words separated by spaces will be treated as an exact phrase.

last note is that the user entered query can be fairly complex - we're rebuilding it to incorporate booleans, stemming, etc. so we'd need to be able to drop the 'exact phrase' into the rest of the search string we use in the contains clause.

thanks!
seth