Simple question.... - Mailing list pgsql-general

... I hope


I have a table with a couple of varchar columns that needs to have all it
values all capitalized.

SO this :

      id|last_name|first_m  |login_id|sex
    ----+---------+---------+--------+---
    1231|Reid     |Samuel R.|sreid   |M

would become :

      id|last_name|first_m  |login_id|sex
    ----+---------+---------+--------+---
    1231|REID     |SAMUEL R.|sreid   |M

This way when I bring them up alphabetically - it will be correct.
I remember seeing this on the list a couple of months ago but I cannot
remember the fix...

Thanks for any advice
Summer