LTRIM & RTRIM

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Sun, 20 Mar 2005 20:30:40 -0800 (PST)
Message-ID: <20050321043040.10271.qmail@web52908.mail.yahoo.com>

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

Received on Sun Mar 20 2005 - 23:34:16 CST