This function is only available when connected to a Teradata database.
The non-standard Bytes function is supported for determining the length of variable byte data. When used with fixed length byte data, the defined column length is always returned. When dragging a Bytes operator into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Other > Bytes
A byte column and/or expression for which to get the length can be moved into the (empty) branch of the tree.
When used in conjunction with the Trim function, the Bytes function can also be used to determine the length of fixed length byte data by first trimming null-byte characters, as shown below.
Variable Creation > Input > Variables: SQL Elements pane - Other > Bytes > Trim
