Re: Oracle case-insensitive

On Thu, 2 Nov 2000, Jamie Alessio wrote: > To: Adi Wibowo <adiw@peter.petra.ac.id>, php-db@lists.php.net > > Hi, I run a query for Oracle 8i. > > How can I run case-insensitive query against it? Because it always > > case-sensitive. > > > Just uppercase or lowercase everything when you compare it. Use Oracle's built-in > functions for this. I can't think of the exact name of it now but I believe it is LOWER so > a query would look something like this: > > select * from some_table where lower(some_table_field) = lower($some_php_variable) > > Again, check that function name but that's the general idea. Thanks, it is lower() and upper(). Thank you, again. Adi Wibowo ------------------------------- * Work matter : adiw@peter.petra.ac.id * Private matter : adiwibowo@excite.com ------------------------------------------