Quote:
Originally Posted by MarillionFan
Shame, DimPrawn is poo pooing that idea above, shows he only has limited experience 
Yes it's an Oracle 10 Database.
There appears to be some Oracle functionality that does seem to create an index of all combinations(as suggested above) based around 'Oracle Text'. From reading the article, it can also be designed to use a fuzzy logic match.
The only problem appears to be if the index is greater than the actual original column, but then again an index using an equal would be quicker than a wildcard anyway
Is this a good method?
http://209.85.173.104/search?q=cache...lnk&cd=1&gl=uk |
I have no idea as I have next to zero technical capability. Reason I asked the question regarding the front end is I know there is standard functionality in oracle apps that does the exact searches you mentioned i.e. retrieves customers via wildcard, indexed and fuzzy searches. As there are also API's, pre-built interface to D&B I figured you may be able to look at how oracle have already done it as a starter for 10.