Right on Tim, thanks for the info! I will plug away at it a little bit and let you know what I find.
Thanks again, M -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:33 PM To: CF-Community Subject: RE: SQL Sounds Like Matching http://info-it.umsystem.edu/oradocs/doc/server/doc/CO20APP/ch10.htm#fnccntn Down the page some they have a decent description of contains. Only problem is I can't get it work like the examples I am seeing in the book. I can use the soundex() function in oracle no problem: Select * from members where soundex(cFirstName) = soundex("tim") When I try to use contains the way it says to like: Select * from members where contains(cFirstName, "Tim") It's throwing an erro sayin gthat the column name is bad, highlighting the word contains in toad. I haven't tried it in SQL+ yet but will do so now that I thought of it :) VarChar2() should be what it's built for. I can't imagine it's going to do clob or blob searches :) Tim -----Original Message----- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:15 PM To: CF-Community Subject: RE: SQL Sounds Like Matching 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5