# What are SQL scalar functions?

Source: https://zilliz.com/ai-faq/what-are-sql-scalar-functions
Author: zilliz

SQL scalar functions are predefined functions that perform operations and return a single value based on the input provided. These functions are commonly used in SQL queries to manipulate, convert, or retrieve data in a more efficient manner. Unlike aggregate functions, which operate on a set of values and return a single aggregated result, scalar functions work on individual row values. This allows developers to make their queries more dynamic and flexible.

There are many types of scalar functions available in SQL, including string functions, numeric functions, date functions, and conversion functions. For instance, the `LEN()` function calculates the length of a string, while the `UPPER()` function transforms all characters in a string to uppercase. If you want to work with dates, the `GETDATE()` function retrieves the current date and time, whereas `DATEDIFF()` can be used to calculate the difference between two dates in specified units. Numeric functions like `ROUND()` can round numbers to a specific number of decimal places, making it easier to present data accurately.

Using scalar functions can significantly streamline SQL queries, allowing developers to simplify complex expressions without needing to use additional temporary tables or complex joins. For example, by using `CONCAT()` to combine first and last name fields directly within a `SELECT` statement, developers can retrieve formatted output with minimal effort. Moreover, these functions can enhance the readability and maintainability of queries by encapsulating logic that could otherwise clutter the SQL code. Overall, scalar functions are powerful tools in a developer's toolkit, helping to manipulate and present data effectively within SQL databases.