Syntax
STRING_LENGTH(Argument)
Description
The STRING_LENGTH SQL scalar function returns the length of a value.
The argument can be any value.
The result of the function is a large integer.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The result is the length of the argument. The length of strings includes blanks. The length of a varying-length string is the actual length, not the maximum length.
Example
Assume the column ADDRESS is a varying-length character string with a value of '895 Don Mills Road'.
STRING_LENGTH(ADDRESS)
Returns the value 18.
List of SQL scalar functions by topic