for now im not going to do verity BUT it is full text indexed would using CONTAIN instead of like make any difference?
> >Well, the easy way is to just add 'bats' to your words table -- this also >will help with plurals for which the trailing s doesn't necessarily apply, >i.e. gooss, octopuss or mooses... ;P > >You could also add an or to your sql statement and another like, although >for this sort of functionality you usually want to go with Verity indexing >-- which will also improve your overall speed at the expense of forcing you >to update your dictionary and your dreams catalog ( in Verity ) >periodically >and not getting "up to the second" results from the dream catalog when you >perform these searches. > >If you don't want to get into the Verity stuff and you don't want to padd >your dictionary, here's the other sql syntax > >SELECT DISTINCT DJ_Dictionary.Word >FROM DJ_Dictionary >WHERE '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + ' %' >OR '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + 's %' >ORDER BY DJ_Dictionary.Word ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm