How to: |
The ARGLEN function measures the length of a character string within a field, excluding trailing spaces. The field format in a synonym specifies the full size of a field, including trailing spaces.
ARGLEN(length, source_string, output_format)
where:
Integer
Is the number of characters in the source_string field.
Alphanumeric
Is a character string whose length, without trailing blanks, is to be returned.
Integer
ARGLEN determines the length of the character string in LAST_NAME and stores the result in a column with the format I3:
ARGLEN(15, LAST_NAME, 'I3')
For SMITH, the result is 5.
For BLACKWOOD, the result is 9.
iWay Software |