Re: [ADMIN] Case insensitive

[Peter Eisentraut]

> select * from userdata wher name = 'John'
> 
> select * from userdata wher name = 'joHN'
> 
> will fetch me the same results.

select * from userdata where lower(name) = 'john'


-- 
Peter Eisentraut                  Sernanders väg 10:115
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden