Re: Help with SELECT and string

> Now when I'm searching database for word "chris" i can't find word
> "Chris" - how the SELECT should looks like?

select name from nametable where lower(name) = 'chris';

or

select name from nametable where upper(name) = 'CHRIS';

-Nick

PS: I'd suggest taking general SQL questions like this to the pgsql-general
list.

---------------------------------------------------------------------
Nick Fankhauser

Business:
nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/

Personal:
nick(at)fankhausers(dot)com http://www.fankhausers.com