About

Scalar functions return a single value (as opposed to an array).

Mathematics definition: Any function whose domain is a vector space and whose value is its scalar field.

Is the result of a scalar function on a numeric a change of scale ?

Example

  • LEN() - Returns the length of a text field
  • ROUND() - Rounds a numeric field to the number of decimals specified
  • NOW() - Returns the current system date and time
  • TRIM() - Strip whitespace (or other characters) from the beginning and end of a text field
  • Regular Expression
  • Text - Concatenation Function
  • Binary Functions