Re: [GENERAL] convert result to uppercase

2004-04-21 Thread Andrew Kelly
On Tue, 2004-04-20 at 23:39, Janning Vygen wrote: Am Dienstag, 13. April 2004 14:17 schrieb Victor Spång Arthursson: Hi! How do i convert a result to upper/lowercase? This is a question SELECT UPPER(lang) from languages; and this is the answer. It works exactly like this:

[GENERAL] convert result to uppercase

2004-04-20 Thread Victor Spång Arthursson
Hi! 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 Sincerely Victor ---(end of broadcast)--- TIP 7: don't forget to increase your

Re: [GENERAL] convert result to uppercase

2004-04-20 Thread Janning Vygen
Am Dienstag, 13. April 2004 14:17 schrieb Victor Spng Arthursson: Hi! How do i convert a result to upper/lowercase? This is a question SELECT UPPER(lang) from languages; and this is the answer. It works exactly like this: SELECT UPPER('dk'); results in 'DK' kind regards, Janning

Re: [GENERAL] convert result to uppercase

2004-04-20 Thread Lee Harr
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