I am trying to do a SIMILAR TO query and can't this one worked out.
In my database I have "Robocop"
I want this to come back as a result if the user types in any of the following
Robocop Collectors Edition
Critieon Collection Robocop
and so on.
I know how to look for the reverse (searching Robocop in a datafield with Robocop Blu-ray in it) but not this way.