LENGTH()

Scalar. Returns the length of a given string or BLOB, in characters or bytes, respectively.

Syntax

LENGTH(value)

Data Types
Return	value
Integer	String
Integer	BLOB

The following example returns the length of the string found in Trades.StockName:

INSERT INTO OutStream
SELECT LENGTH(Trades.StockName)
FROM Trades;