Re: Case Sensitivity Problem in Pl/SQL

Nate Bensch wrote:
>
> Is there a function that takes a string value and returns it in all
> caps!? If there is, what is it and how is it called
>
> - Nate Bensch
declare

   l_user varchar2(20) := 'lbarber';
   l_test varchar2(1);
begin

   select 'Y'
   into l_test
   from dual
   where user = upper(l_user);

exception

   when no_data_found then

      l_test = 'N';
end; Received on Tue Oct 29 1996 - 00:00:00 CET