Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to do a "fuzzy" or approximate matching of strings in a SQL where clause

Re: How to do a "fuzzy" or approximate matching of strings in a SQL where clause

From: D Goyal <goyald_at_gmail.com>
Date: 8 Aug 2005 10:31:31 -0700
Message-ID: <1123522291.474278.110070@g14g2000cwa.googlegroups.com>


AFAIK soundex will check for similar sounding words. I am looking for simillar phrases.
For example

1. "SQL server help request"
2. "Re: Re: SQL Server help   request - followup"
3. "FW: forwarded for your attention: SQL Server help request "
My application will be a helpdesk system where I want to check for subject line, search for similar instances that happen in past and do something.

Thanks Received on Mon Aug 08 2005 - 12:31:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US