Scalar functions are used to return a single value based on the input values.
Scalar Functions are as follows:
UCASE() : Converts the specified field in the upper case.
LCASE() : Converts the specified field in lower case.
MID() : Extracts and returns character from the text field.
FORMAT() : Specifies the display format.
LEN() : Specifies the length of the text field.
ROUND() : Rounds up the decimal field value to a number.
