upper() vs. lower()

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