try:
where soundex(cFirstName) = soundex('tim')
use single quotes instead of double quotes
>>> [EMAIL PROTECTED] 03/27/03 03:33PM >>>
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
