CodesJava

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

Posted in SQL   


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap