LTRIM & RTRIM

From: Kean Jacinta <jacintakean@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Sun, 20 Mar 2005 20:30:40 -0800 (PST)

Need some clarification here.

WHILE V_FROMDate <= TODATE LOOP 
   IF RTRIM(TO_CHAR(V_FROMDate,'DAY'))='SATURDAY' THEN
   V_Count := V_Count + 1;
   END IF;
   V_FROMDate := V_FROMDate +1;

When i use RTRIM --it will generate correct result ,
if i use LTRIM then the system will return 0.

Aren't RTRIM and LTRIM sort of the same ?

PLs help up . THank u 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: LTRIM & RTRIM
From: Stephane Faroult

LTRIM & RTRIM

Other related posts: