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?
>
http://www.mysql.com/doc/S/t/String_functions.html
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to
the current character set mapping (the default is ISO-8859-1 Latin1):
mysql> select UCASE('Hej');
-> 'HEJ'
This function is multi-byte saf