Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fuzzy search
In article <1074784505.698129_at_yasure>, damorgan_at_x.washington.edu says...
> 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%';
>
>
Of course that would also bring back 'Ambrose Corporate Services' so
isn't a total solution?
-- jeremyReceived on Thu Jan 22 2004 - 09:25:34 CST