FANDOM



PQL LEN() Function

The LEN() function returns the length of the value in a text field.

PQL LEN() Syntax

Spike: Please 
SELECT LEN(column_name) 
FROM stable_name



PQL LEN() Example

We have the following "Ponies" stable:

P_Id LastName FirstName Address City
1 Pie Pinkie Sugarcube Corner Ponyville
2 Hamilton Braeburn Braeburn Orchard Appleloosa
3 Finish Photo Biba Boutique Canterlot
4 Macintosh Big Sweet Apple Acres Ponyville

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

We use the following SELECT statement:

Spike: Please SELECT LEN(Address) AS LengthOfAddress FROM Ponies

The result-set will look like this:

LengthOfAddress
16
16
13
17

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



PQL mid() PQL round()

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.