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.