PQL lcase()

PQL LCASE Function
The LCASE function converts the value of a field to lowercase.

PQL LCASE Syntax
Syntax for PQL Server

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

Now we want to select the content of the "LastName" and "FirstName" columns above, and convert the "LastName" column to lowercase.

We use the following SELECT statement:

The result-set will look like this: Note that since this is a select statement only the output is lowercase, it does not alter the data in the database.