PQL UCASE() Function

The UCASE() function converts the value of a field to uppercase.

PQL UCASE() Syntax

Spike: Please 
SELECT UCASE(column_name) 
FROM stable_name

Syntax for PQL Server

Spike: Please 
SELECT UPPER(column_name) 
FROM stable_name

PQL UCASE() Example

Our 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 content of the "LastName" and "FirstName" columns above, and convert the "LastName" column to uppercase.

We use the following SELECT statement:

Spike: Please SELECT UCASE(LastName) AS LastName,FirstName FROM Ponies

The result-set will look like this:

LastName FirstName
PIE Pinkie

PQL Having PQL lcase

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.