Easy learning with example program codes

what are scalar functions in sql?

Scalar functions are used to return a single value based on the input values (one or more values).

SQl scalar functions

  • UCASE(): It converts the specified field in upper case
  • LCASE(): It converts the specified field in lower case
  • MID(): It extracts and returns character from text field
  • FORMAT(): It specifies the display format
  • LEN(): It specifies the length of text field
  • ROUND(): It rounds up the decimal field value to a number

Related topics

Please follow and like us:
Posted in SQL   

Copyright © 2020 CodesJava Protection Status