how can I make a "LIKE" select with case insensitivity using Oracle ?????
| From: | Joey Garcia | Date: | Wed, 06 Sep 2000 20:50:35 +0000 |
| Subject: | how can I make a "LIKE" select with case insensitivity using Oracle ????? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2670@lists.php.net to get a copy of this message | ||
A company name is "Xavor"
and I want to prompt a user (using WML) to type in the first 2 characters of
a company name then perform select on it, such as :
select company from mytable where company like 'xa%' #this returns nothing
select company from mytable where company like 'Xa%' #this returns Xavor
Any help would be appreciated
-- Joey