View Single Post
  #6 (permalink)  
Old 12-18-06, 09:21
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,083
ok, that's going to require that you split out every word in the column individually

this may require a cross join with a numbers table

what's this for? how often are you going to use it?

the query will definitely not be easy to write, nor efficient to run
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote