You can use either ucase() or upper() functions.
ucase(str) or upper(str)
Seung-woo Nam
Zhu George-CZZ010 wrote:
> There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
On Tue, 27 Mar 2001 11:22:20 -0600, Zhu George-CZZ010
<[EMAIL PROTECTED]> wrote:
I believe it's upper(col_name)
>>There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
his function is multi-byte safe.
Cal
http://www.calevans.com
-Original Message-
From: Zhu George-CZZ010 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:22 AM
To: [EMAIL PROTECTED]
Subject: to upper case function
There's a function in SQL to convert strings to upper cas
There's a function in SQL to convert strings to upper case (sounds like to_upper()? ),
I don't have the reference book at hand, does anyone know the syntax or that function?
Thank you very much in advance.
-
Before posting, pl