Using Scalar Functions to Manipulate Data Row-by-Row

You may want to create queries that do things like manipulate dates or perform arithmetic on your data. The ODBC standard defines a number of date, time, numeric, and string functions for your use. These are called scalar functions. Unfortunately, not all are supported by every type of database.