I wouldn't expect it to make a difference -- checking for plurals is a "semantic" (may not be the right technical term) search criteria -- it's not something that can be easily defined, even with a regular expression because the rules are often specific to an individual word, so it requires its own set of dictionaries, etc. in order to make it a "natural language" result. That's why I recommended possibly using Verity. Not sure what other technologies provide that, but I don't _think_ MS full-text indexing is one of them. I could be wrong.
> 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 s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
