Jeremy wrote:
> 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?
A "total" solution doesn't exist. There is a nearly infinite number of
possible inclusions and exclusions.
--
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 - 12:28:01 CST
