What I need to do is split the words in column A into separate Words in Column B.
Column A "Jobber Drill 2.0mm"
I Need Column B To Read
"jobber obber bber ber er drill rill ill ll 2.0mm .0mm 0mm mm"
This is Each word in column A then the same word again - Dropping the first character until only 2 characters left.
What I am attempting to do is find a way to use full text search to search for any part of a word.
(I have a utility for searching products on a tablet that uses SQL 2008 Express and it is slow when searching with like '%dril%' and like '%2%')
I want to try using contains(description ,'"dril*"' or '"2*"')
Any Other suggestions on speeding the search up would be appreciated.
(It is only returning 5 Columns of data and often only a dozen rows. The Table has 87,000 Records)