Expression: Maximum Selects the maximum value of an expression Value: Degrees Converts radians into degrees String1: String2: Concat Concatenates two character strings Angle: Tangent Returns the tangent of an angle Character string: Rtrim Removes blank characters from the right of a character string Angle: Sine Returns the sine of an angle Character string: Lowercase Returns a character string in lower case Date: DayOfYear Returns the day of the year (1-366) Set of values: Sum Returns the sum of the values Value: Expression: Result1: Result2: Case Returns a value that depends on which one of the specified conditions is met String1: Initial position: Number of characters: String2: Stuff Replaces a sequence of characters with other characters ASCII code: Character Returns the character that corresponds to the ASCII code Question: Numeric Prompt Prompts the user to enter a specific value Expression: Number of times: Replicate Repeats a character expression n number of times Value: Log10 Returns the base 10 logarithm of the specified value Value: Random Returns a random number between 0 and 1. Value: ArcSine Returns the arc sine of a numerical expression Value: Radians Converts degrees into radians Date: Number of the week Returns the number of the week (1-52) Value: Power: Power Returns a value raised to the nth power Str Returns a value set to a specific length Number to round: Precision: Round Returns a number rounded to n decimal places Date: DayOfMonth Returns the day of the month (1-31) First argument: Second argument: If Null Returns the first argument if it is not null, the second one otherwise Angle1: Angle2: AngleTangent2 Returns the angle in radians whose tangent is Angle1/Angle2 Pattern: Character string: Patindex Returns the position of a character in a character string Date: DateToChar Converts a date into a character string Character: ASCII Code Returns the ASCII code of the character. Pi Returns the constant value of 3.1415926535897932 Expression: Minimum Selects the minimum value of an expression Character string: Soundex Returns a character string that phonetically represents the word(s) in the string Date: Number of the month Returns the number of the month (1-12) Value: ArcTangent Returns the arc tangent of a numerical expression Expression: Character string: Charindex Returns the position of an expression in a character string Number of blank characters: Space Returns a string with the number of blank characters Date: Year Returns the year Value: ArcCosine Returns the arc cosine of a numerical expression Search: Character string: Locate Returns the position of a character in a character string Value: Divided by: Mod Returns the remainder of a division Value: Exp Returns the exponential value of the specified value Character string: LeftRemove Removes blank characters from the left of a character string Numerical expression: Floor Returns the value of a number rounded down to the nearest integer Character string: Reverse Reverses a string of characters Conversion Converts datatypes Date: Quarter Returns the quarter Set of values: Average Returns the average value of a set of values Character string: Length: Left Returns a specified number of characters from the left of a character string Number: NumberToChar Converts a number into a character string Model: Date: DateExtract Extracts part of a date Question: Character Prompt Prompts the user to enter a specific character Numerical expression: Ceil Returns the value of a number rounded up to the nearest integer Expression: IsNull Returns TRUE if the expression is NULL Angle: Cotangent Returns the cotangent of an angle in radians Numerical expression: Absolute Returns the absolute value of a given expression String1: String2: Difference Returns the difference between the SOUNDEX value of two strings Character string: Number of characters to extract: Rightpart Returns a specified number of characters from the right of a character string Value: Log Returns the natural logarithm of the specified value Character string: Initial position: Number of characters: Substring Extracts a sequence of characters from a character string Character string: Uppercase Returns a character string in upper case Current Date Returns the current date Question: Date Prompt Prompts the user to enter a specific date Character string: Length Returns the length of a character string Number: Sqrt Returns the square root of a number Expression: Count Returns the number of non-NULL values of Expression in the rows retrieved by a SELECT statement Value: Sign Returns a number that represents the sign of the specified number Angle: Cosine Returns the cosine of an angle Date: DayOfWeek Returns the day of the week (1 equals Sunday)