Scalar function in SQL

Scalar function

Scalar function:  Scalar function takes one or more parameters and returns a single value

These functions are based on user input, these too returns single value.

•  UCASE()
• LCASE()
•  MID()
•  LEN()
•  ROUND()
•  NOW()
•  FORMAT()