Re: Right()

is this what you're after?
Steve

tsoadm(14)@SMP> l
  1 select substr ( 'left or right', -5) right   2 , substr ( 'left or right', 1, 4) left   3* from dual
tsoadm(14)@SMP> /

RIGHT LEFT
------------ ------------
right left

1 row selected.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, December 23, 2002 9:49 AM

> Please don't laugh. What is the equivalent of a Right() function in
> Oracle? I want to be able to sort a column numerically whose string
> contents takes the format "v1, v2, v3, v4". I was after something like:
>
> ORDER BY Cast(Right(lt_tk_id, Length(lt_tk_id - 1)) as int)
>
> but it's not playing nice. Order by Right(lt_tk_id, 1) gives the same
> error, so I assume that's where it's falling down. I've searched
> everywhere I can think of for "right function", Oracle online docs,
> Enterprise Manager docs, Google, but nothing seems to come close.
>
> BTW, is it my imagination or do the docs leave a lot to be desired?
>
>
> Thanks
>
> --
> Aidan Whitehall <aidanwhitehall_at_fairbanks.co.uk>
> Macromedia ColdFusion Developer
> Fairbanks Environmental Ltd +44 (0)1695 51775
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Aidan Whitehall
> INET: AidanWhitehall_at_Fairbanks.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve Perry
  INET: sperry_at_sprynet.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).