>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