Scalar Functions

Scalar functions transform or calculate individual values in a query. Use them for string processing, date and time arithmetic, numeric calculations, null handling, and type conversion. They can appear in expressions such as filters, projected columns, and grouping keys.