Re: help searching for oracles and Oracles and ORACLES

Hi Jon,

I would suggest the following:

       select * from table2 where instr(lower(description),'oracle') > 0;

lower will make all the characters in the description field lowercase so you only need to test for lower case characters.

instr will return > 0 if it finds any occurance of the word 'oracle'

Hope this helps,
C Received on Tue Feb 19 2008 - 00:31:48 CST