Tim; Thanks for the response. I am going to get that book.
What datatypes can CONTAINS() work against? I am trying it against a varchar2 field and it is giving me problems. M -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:08 PM To: CF-Community Subject: RE: SQL Sounds Like Matching I got the SQL Server versions difference() and soundex() working in just a few tries. I am working on the oracle kind using contains() with a ! modifier in front of the value your searching against. Oracle 8i The Complete Reference (Oracle Press) has a nice section on all different kinds of advance searches. Turns out you can even do thesauri searches, to look for similar meanings. Crazy huh? Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
