Re: SubStr( var, -1, 3 ) !!
From: nobody <nobody_at_nowhere.com>
Date: Mon, 02 Dec 2002 23:53:42 GMT
Message-ID: <aoSG9.263$%71.213_at_news01.bloor.is.net.cable.rogers.com>
Date: Mon, 02 Dec 2002 23:53:42 GMT
Message-ID: <aoSG9.263$%71.213_at_news01.bloor.is.net.cable.rogers.com>
select substr('test',-3) from dual
"Jorge Pinto" <jorgep_at_sympatico.ca> wrote in message
news:QYRG9.1312$rv5.405785_at_news20.bellglobal.com...
> Hello everyone,
>
> Do you know what should I do to get the last three characteres from a
> field...
>
> i.g. Substr( "test",-1,3) and I got only "t", instead of "est"....
>
> Could you help me ??
>
>
> Thanks,
>
> Pinto, Jorge
>
>
Received on Tue Dec 03 2002 - 00:53:42 CET