Thread: uppercase of char16

uppercase of char16

From
Safa Pilavcı
Date:
hello ,
My problem is with SQL statement,
I have a field like,
    my_field    char16

this field contains chars all lowercase but I want toget them uppercase as a
result of select statement..
I have tried ;
    select upper(my_field) from my_table;
but the followwing error occured.

function upper(char16) does not exist

How can I get uppercase output of my_field....


Safa Pilavcı