Re: convert result to uppercase

>How do i convert a result to upper/lowercase?
>
>I'ld like to do the following:
>
>SELECT UPPER(lang) from languages;
>
>and get for example "uk" as "UK", "dk" AS "DK" and so on?
>


That looks right to me. Are you getting an error?

lee=# select version();
                               version
---------------------------------------------------------------------
PostgreSQL 7.4.2 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
(1 row)

lee=# select UPPER('MixED CaSes');
    upper
-------------
MIXED CASES
(1 row)

lee=# select lower('MixED CaSes');
    lower
-------------
mixed cases
(1 row)

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus