SQL Scalar Functions

This function returns a single value based on an input value

UCASE()

This function converts a character string to UPPER CASE

 

LCASE()

This function converts a character string to LOWER CASE

 

LEN()

This functions returns the length of a text field.

 

ROUND()

This function rounds a numeric field to the number of decimal specified