|
Note:
|
If you are using an Alpha variable of size 20, then Len (A) will return 20 regardless of what is in the string. It is advisable to use this together with the Trim function to remove trailing blanks.
To retrieve the actual length of an Alpha column, use Len(RTrim(field)). If A is a 20- character Alpha column containing the string 'John ___ ', where ____ implies blanks, Len (RTrim(A)) returns 4.
|
