[POSTGRES] SQL Noob: LIKE and ignore case?
Is there anyway to use the like clause but have it ignore upper/lowercase differances?
I see it is possible to upper/lower case the letters themselves before doing the expression, but that is kind of useless if you don't know what the case is inside the database more then likely mixed case.
(ps, im actually using postgres..but I'm assuming there must be standard sql way to do this).
In the long run I will probably need a better keyword indexing strategy, but this is just to get basic 'search' working for now on my project.
Last edited by guelphdad; 08-16-2006 at 08:20 PM..
Reason: change title and move to correct forum