The standard character length function is supported for determining the length of variable character data. When used with fixed length character data, the defined column length is always returned. When dragging a Character Length operator into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - String Functions > Character Length
A column and/or expression for which to get the character length can be moved into the (empty) branch of the tree.
When used in conjunction with the Trim function, the Character Length function can also be used to determine the length of fixed character length data by first trimming pad characters, as follows.
Variable Creation > Input > Variables: SQL Elements pane - String Functions > Character Length > Trim
