what is the best way to do a case insensitive search?
Hi Guys,
hopefully a quick one, anyone know what the best way to perform a case-insensitive search is? at the moment many of our stored procedures perform selects against un-indexed fields (e.g. product title) and to avoid casing problems we have an UPPER around the field name and the variable e.g.
AND (nvcproducttitle IS NULL OR
UPPER(p.NVCTITLE) LIKE '%' || UPPER(nvcproducttitle) || '%')
This seems to work just fine but on a large catalogue (10 million+) it can take 50-60 seconds to return.
Any pointers would be appreciated,
J