Re: convert result to uppercase

From: Janning Vygen <vygen(at)gmx(dot)de>
To: Victor Spång Arthursson <scooterbabe(at)home(dot)se>, pgsql-general(at)postgresql(dot)org
Subject: Re: convert result to uppercase
Date: 2004-04-20 21:39:25
Message-ID: 200404202339.25145.vygen@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:

SELECT UPPER('dk');

results in 'DK'

kind regards,
Janning

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2004-04-20 22:38:56 [OT] MySQL AB Launches MySQL Cluster
Previous Message Gralewski Daniel 2004-04-20 21:32:07 tsearch2 and bytea