SQL scalar functions

Question 1

What scalar functions.

Answer 1

SQL scalar functions return a single value, based on the input value

Question 2

Converts to upper case?

Answer 2

UCASE() - Converts a field to upper case

Question 3

What function converts to lower case?

Answer 3

LCASE() - Converts a field to lower case

Question 4

What extracts characters from a text field?

Answer 4

MID() - Extract characters from a text field

Question 5

What returns the length of a text field?

Answer 5

LEN() - Returns the length of a text field

Question 6

What rounds a numeric field to the number of decimals specified?

Answer 6

ROUND() - Rounds a numeric field to the number of decimals specified

Question 7

What function returns the current system date and time?

Answer 7

NOW() - Returns the current system date and time

Question 8

What formats how a field is to be displayed?

Answer 8

FORMAT() - Formats how a field is to be displayed