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