Subject | Trimming Trailing Blanks Using Autocast |
---|---|
Author | Hardy Sherwood |
Post date | 2007-10-17T16:16:53Z |
I've defined several columns as CHAR in external tables and inserted these
into VARCHAR columns in internal tables. I was told that doing so would
trim the trailing blanks from the corresponding fields.
When I tested this by using the STRLEN function on the VARCHAR columns in
the internal table, the resulting length was the full size of the column.
In other words, the trailing blanks were not trimmed.
Please let me know what did I do wrong? Why weren't the trailing blanks
removed?
Thanks,
Hardy
-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.
The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------
into VARCHAR columns in internal tables. I was told that doing so would
trim the trailing blanks from the corresponding fields.
When I tested this by using the STRLEN function on the VARCHAR columns in
the internal table, the resulting length was the full size of the column.
In other words, the trailing blanks were not trimmed.
Please let me know what did I do wrong? Why weren't the trailing blanks
removed?
Thanks,
Hardy
-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.
The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------