db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Query and uppercases
Date Wed, 26 Apr 2006 15:52:36 GMT
> Is there a way to bypass this, so when querying the database it does not 
> look at uppercases or lowercases. è Detroit = detroit = dEtRoIt = …

Try using the UPPER function:

select * from city_info where UPPER(city_name) = 'DETROIT';

thanks,

bryan



Mime
View raw message