In SQL, you can create a function using the CREATE FUNCTION statement. The syntax for creating a function varies slightly between database management systems (DBMS) as SQL implementations may differ.

Breaking out of limitations imposed by Microsoft on user-defined functions in SQL Server. Do you know what's the first thing Microsoft tells you in their Create User-defined Functions article?