Re: SubStr( var, -1, 3 ) !!
From: Alex Filonov <afilonov_at_yahoo.com>
Date: 2 Dec 2002 20:54:34 -0800
Message-ID: <336da121.0212022054.2abb3402_at_posting.google.com>
Date: 2 Dec 2002 20:54:34 -0800
Message-ID: <336da121.0212022054.2abb3402_at_posting.google.com>
"nobody" <nobody_at_nowhere.com> wrote in message news:<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"....
substr('test', length('test') - 2, 3)
> >
> > Could you help me ??
> >
> >
> > Thanks,
> >
> > Pinto, Jorge
> >
> >
Received on Tue Dec 03 2002 - 05:54:34 CET