Re: pls help w/conversion pblm

On Sun, 22 Jul 2001 06:32:24 GMT, "rmartes" <rmartes_at_usa.net> wrote:
> If the last letter of someone's name end with s, I will like to be able to
> have my form letters end s'.

select decode(substr(name,length(name),1),'s',name||'''',name) name from people;

Elvis' Received on Sun Jul 22 2001 - 20:53:56 CDT