[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQR version 2.5.7 on DEC AXP Platform



Ed,

   RTRIM in SQR V2.5.7 works the way RTRIM works in SQL.  Try these 
selects in SQL.

Select ltrim('12345','123') from dual;

  RETURN VALUE: 45

Select rtrim('12345','123') from dual;
  
  RETURN VALUE: 12345
 
No try this:  Select rtrim('12345','543') from dual;

  RETURN VALUE: 12

  Since you are trying to RTRIM(X,Y) it is reading X from right to left and
reading Y from left to right searching for matches until Y is no longer 
found in X.  Thusly your RTRIM('123456789','123456789') is not 
working 9 in X does not match 1 in Y and so on.  For this to work you need 
RTRIM('123456789','987654321').  Hope this helped a little.

                               David
----------------------------------------------------------------------------
  KINGD@RANDD.ABBOTT.COM                             David R. King    
  Abbott Laboratories Inc.                           Research Computing

  Time is a train that changes future to past....
-----------------------------------------------------------------------------