Thread: upper() vs. lower()

Is there any reason why everyone suggests to use upper() to do a case
insensitive search rather than lower()?

Will initcap() capitalize each word in a column, or just the first word?

Soma Interesting writes:

> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?

I generally use lower()...  So, no.

> Will initcap() capitalize each word in a column, or just the first word?

Each word of the argument.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

I know that if you move towards unicode, you'll probably do better by going
to lowercase since I understand that there are more lowercase letters than
uppercase (for some odd reason!).  I think it's related to the fact that
some languages have multiple lowercase letters that will map to a single
uppercase letter, so there's great "distinct-ness" with lowercase.

David

> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?
>
> Will initcap() capitalize each word in a column, or just the first word?