Scalar Functions - BrainDump

Scalar functions work against one value and return one value based on the input. Aggregate functions work on a bunch of data and return one result. I understand if you fell asleep during that; I did just writing it.

Here is a table of scalar functions.

UCASE(c)

If you want make all the characters of a selected item uppercase, you can use the UCASE function, like so:

Select UCASE('darth ladel') from Employees;

This will return the following: DARTH LADEL

LCASE(c)

Likewise, you may also wish to force all of the characters to be lowercase.

Select LCASE('Darth Brooks') from Employees;