Salesforce Marketing Cloud SQL implementation does not support user-defined functions. There are, however, multiple built-in functions that are useful on a day-to-day basis when working with queries.

DB2 Data Types Every column in a table has a name and a data type. The data type tells DB2 how much physical storage to set aside for the column and the form in which the data are stored. DB2 uses IBM ...

In order to do calculations with this numeric data, you must convert the character columns to numeric. You can use Subset/Copy on the Data Management menu to change a column from a character to a ...