What does datalength(rtrim...) do? I can guess the datalength, but
what is rtrim? I am running ASA 7.0.

TIA,
Dave...

On Tue, 17 Feb 2004 13:34:32 -0800, Dave Rupp wrote:

rtrim() is "right trim" - remove spaces from the right of the string.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Dave,

Trim is for removing the extra spaces in the data.
rtrim is for removing space in the right side of the data, and ltrim
for left side.
take the example:
' Dave ' <---- length is 6
rtrim(' Dave ') <-----Now triming spaces in the right side so the
length is 5.
ltrim(' Dave ') <-----Now triming spaces in the left side so the
length is 5.
ltrim(rtrim(' Dave ')<----trimging spaces in both sides so the length
is 4.

Use depends upon the situation.

select length = datalength(' Dave ') ,
rtrimoflenghth = datalength(rtrim(' Dave ')),
ltrimoflength = datalength(ltrim(' Dave ')) ,
alltrimoflength = datalength(rtrim(ltrim(' Dave ')))
__________________________________________________ ____

Regards,
Ram DSL, London.
www.dslsoft.net
__________________________________________________ _____


a0157202 (AT) yahoo (DOT) com (Dave Rupp) wrote in message news:<c8dba183.0402171334.4e89a026 (AT) posting (DOT) google.com>...