ltrim & rtrim

From: Michael Barger <mbarger_at_verio.net>
Date: Mon, 08 Mar 1999 14:35:13 -0600
Message-ID: <36E43481.3E79_at_verio.net>



I wonder if anyone could help me understand why I cannot get the number values in the following statements:

select LTRIM('Internet News##129::136','##') "testing" from dual;

testing



Internet News##129::136

{I want the 129::136 as the return value. Can someone help?}

-- 

**********************************************************************
Michael Barger http://www.verio.net Verio, IT group ph. 888-GET-VERIO Live in peace with each other. And we urge you, warn those who are idle, encourage the timid, help the weak, and be patient with everyone
**********************************************************************
Received on Mon Mar 08 1999 - 21:35:13 CET

Original text of this message