On Wed, Mar 07, 2007 at 12:28:57AM -0300, [EMAIL PROTECTED] wrote: > Well, im wondering if is possible using LIKE '%blah%', even better would be > upper/lower(string) like '%blah%',
Your better bet then is either to index lower(string) or better, on insert convert everything to lower(). A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings