PQL len()

PQL LEN Function
The LEN function returns the length of the value in a text field.

PQL LEN Example
We have the following "Ponies" stable:

Now we want to select the length of the values in the "Address" column above.

We use the following SELECT statement:

The result-set will look like this:

Please note that LEN will count whitespaces as long as it's followed by a wordcharcter but will trim trailing whitespaces.