0 votes
in Sql by
What are Scalar functions in SQL?

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Nov 26, 2020 in Sql by SakshiSharma
0 votes
asked Jan 14, 2021 in JSON by RShastri
...