Re: pls help w/data conversion

Here is one possibility:

create or replace function s_at_end(n varchar2) return varchar2 is
begin

   if substr(upper(n),length(n),1) = 'S' then

      return n || '''';
   else

      return n;
   end if;
end;
/

Frank Hubeny

rmartes wrote:

> If the last letter of someone's name ends
> with s, I will like to be able to have my
> form letters convert to s'.
>
> Thanks
Received on Mon Jul 23 2001 - 00:23:29 CDT