[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
- Subject: Re: SQR version 2.5.7 on DEC AXP Platform
- From: KINGD@randb.abbott.com
- Date: Sat, 4 Mar 1995 01:49:50 -0700
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....
-----------------------------------------------------------------------------