SQL – SQL Server IIF() Function
The SQL Server IIF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.
SQL – SQL Server ISDATE() Function
The SQL Server ISDATE() function checks an expression and returns 1 if it is a valid date, and 0 if it is NOT a valid date.
SQL – SQL Server ISNULL() Function
The SQL Server ISNULL() function returns a specified value if the expression is NULL, and the expression itself if the expression is NOT NULL.
SQL – SQL Server ISNUMERIC() Function
The SQL Server ISNUMERIC() function tests whether an expression is numeric, and returns 1 if the expression is numeric and 0 if it is not numeric.
SQL – SQL Server LEFT() Function
The SQL Server LEFT() function extracts a number of characters (starting from left) from a string.
SQL – SQL Server LEN() Function
The SQL Server LEN() function returns the length of a string. Trailing spaces (after) are not included, but leading spaces (before) are included.
SQL – SQL Server LOG() Function
The SQL Server LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
SQL – SQL Server LOG10() Function
The SQL Server LOG10() function returns the natural logarithm of a number greater than 0 to base 10.
SQL – SQL Server LTRIM() Function
The SQL Server LTRIM() function removes leading spaces from a string. Leading spaces are spaces before (left of) the string.
SQL – SQL Server MAX() Function
The SQL Server MAX() function returns the maximum value in a set of values.
SQL – SQL Server MIN() Function
The SQL Server MIN() function returns the minimum value in a set of values.
SQL – SQL Server MONTH() Function
The SQL Server MONTH() function returns the month part for a specified date (a number from 1 to 12).
SQL – SQL Server NCHAR() Function
The SQL Server NCHAR() function returns the Unicode character based on the number code provided.
SQL – SQL Server NULLIF() Function
The SQL Server NULLIF() function returns NULL if two expressions are equal, or returns the first expression if they are not equal.
SQL – SQL Server PATINDEX() Function
The SQL Server PATINDEX() function returns the position of a pattern in a string. If the pattern is not found, this function returns 0.
SQL – SQL Server QUOTENAME() Function
The SQL Server QUOTENAME() function returns a Unicode string with delimiters added to make the string a valid SQL Server delimited identifier.
SQL – SQL Server POWER() Function
The SQL Server POWER() function returns the value of a number raised to the power of another number.
SQL – SQL Server RADIANS() Function
The SQL Server RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.