What are Scalar functions in SQL?

› Category: SQL › What are Scalar functions in SQL?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

 What are Scalar functions in SQL?

Question Tags:
1 Answers
0 Vote Up Vote Down
Editor">Editor Staff answered 2 years ago

 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.