SQL – SQL Server LOWER() Function
The SQL Server LOWER() function converts a string to lower-case.
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.
SQL – SQL Server RAND() Function
The SQL Server RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – SQL Server REPLACE() Function
The SQL Server REPLACE() function replaces all occurrences of a substring (case-insensitive) within a string, with a new substring.
SQL – SQL Server REPLICATE() Function
The SQL Server REPLICATE() function repeats a specified string a specified number of times.
SQL – SQL Server REVERSE() Function
The SQL Server REVERSE() function reverses a specified string and returns the result.
SQL – SQL Server RIGHT() Function
The SQL Server RIGHT() function extracts a number of characters (starting from right) from a string.
SQL – SQL Server ROUND() Function
The SQL Server ROUND() function rounds a number to a specified number of decimal places.
SQL – SQL Server RTRIM() Function
The SQL Server RTRIM() function removes trailing spaces from a string. Trailing spaces are spaces after (right of) the string.
SQL – SQL Server SESSION_USER Function
The SQL Server SESSION_USER function returns the name of the current user in the SQL Server database.