Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fuzzy search
Al Reid wrote:
> First, I have Oracle 8.1.7.
>
> My "customer" has requested that they be able to retrieve only the correct records from the database where they do not know exactly
> how the data was entered. The are referring to it as a fuzzy search.
>
> For example, the want to retrieve info from a customer database by customer name. The entry in the database is 'A B C Corp'
>
> They want to be able to retrieve the record if the type in any of the following:
>
> A. B. Corp
> A.B. Corp
> AB Corp
> A.B Corp, etc.
>
> I currently use SPs to retrieve the records from a VB program. Is there something I could add to the SP to provide this
> functionality without severely effecting performance?
>
> Thanks.
>
> --
> Al Reid
SELECT ...
FROM ...
WHERE some_column LIKE 'A%B%Corp%';
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Jan 22 2004 - 09:16:13 CST