Re: pls help w/data conversion

On Sun, 22 Jul 2001 07:26:54 GMT, "rmartes" <rmartes_at_usa.net> 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
>
>
>

Hi Martes,

update mytab
set lastname = lastname || ''''
where substr(lastname,length(lastname),1) = 's'

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sun Jul 22 2001 - 06:29:49 CDT