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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings