SQL Server
- SQL Server Math
- SQL Server Trigonometry
- ascii
Returns a number representing the ascii code value of the leftmost character of "string_expression". - char
Returns the character that has the ASCII code value specified by "integer_expression". "Integer_expression" should be between 0 and 255. - charindex
Searches "string_expression2" for the first occurrence of "string_expression1" and returns an integer. "Start_location" is the character position to start searching for "string_expression1" in "string_expression2". If "start_location" is not specified, is a negative number, or is zero, the search starts at the beginning of "string_expression2". - {current_user}
Returns the name of the current user. - datalength
Returns the length in bytes of "string_expression". - dateadd
Returns the date resulting from the addition of "integer_expression" units (indicated by "datepart" (day, month, year)) to "date_expression". - datediff
Returns the number of "datepart" (day, month, year) units between "date_expression1" and "date_expression2". - datename
Returns "datepart" from "date_expression", which can be a datetime, smalldatetime, date, or time value as an ASCII string. Note that "datepart" must be a keyword representing a datepart or its abbreviation recognized by Microsoft® SQL Server and must be enclosed in curly brackets. - datepart
Returns part of "date_expression" (for example, the month) as an integer. "date_expression" can be a datetime, smalldatetime, date, or time value. Note that "datepart" must be a keyword representing a datepart or its abbreviation recognized by Microsoft® SQL Server and must be enclosed in curly brackets. - day
Returns the day portion of "date_expression". Same as extract (day from date_expression). - difference
Returns an integer value representing the difference between the values returned by the data source-specific soundex function for "string_expression1" and "string_expression2". The value returned ranges from 0 to 4, with 4 indicating the best match. Note that 4 does not mean that the strings are equal. - getdate
Returns a datetime value representing the current date and time of the computer that the database software runs on. - isnull
Returns the first non-null argument (or null if both arguments are null). It is recommended to use the sql standard COALESCE function instead. - left
Returns the leftmost "integer_expression" characters of "string_expression". - ltrim
Returns "string_expression" with leading spaces removed. - month
Returns the month portion of "date_expression". Same as extract (month from date_expression). - patindex
Returns an integer that represents the starting position of the first occurrence of "string_expression1" in the "string_expression2". Returns 0 if "string_expression1" is not found. The % wildcard character must precede and follow "string_expression1", except when searching for first or last characters. - replace
Replaces all occurrences of "string_expression2" in "string_expression1" with "string_expression3". - replicate
Returns a string consisting of "string_expression" repeated "integer_expression" times. - reverse
Returns "string_expression" in reverse order. - right
Returns the rightmost "integer_expression" characters of "string_expression". - round
Returns "numeric_expression" rounded to the nearest value "integer_expression" places to the right of the decimal point. Rounding takes place before data formatting is applied. - rtrim
Returns "string_expression" with trailing spaces removed. - sign
Returns an indicator of the sign "numeric_expression": +1 if "numeric_expression" is positive, 0 if zero or -1 if negative. - soundex
Returns a four character string representing the sound of the words in "string_expression". - space
Returns a string consisting of "integer_expression" spaces. - str
Returns a string representation of "numeric_expression" where "integer_expression1" is the length of the string returned and "integer_expression2" is the number of decimal digits. - stuff
Returns a string where "integer_expression2" characters have been deleted from "string_expression1" beginning at "integer_expression1", and where "string_expression2" has been inserted into "string_expression1" at its start. The first character in a string is at position 1. - year
Returns the year portion of "date_expression". Same as extract (year from date_expression).
Parent topic: Using the expression editor