SemQL functions list
SemQL supports an extensive set of builtin functions for PostgreSQL, Oracle, and SQL Server.
The following tables list the builtin functions available in SemQL.
Functions for Oracle
The following functions are available when using Oracle.
Function  Description 


Returns the absolute value of number. 

Returns the arc cosine of number. The argument number must be in the range of 1 to 1, and the function returns a value in the range of 0 to pi, expressed in radians. 

Returns the date in the form <date> plus <integer> months. The date argument can be a datetime value or any value that can be implicitly converted to a date. The integer argument can be an integer or any value that can be implicitly converted to an integer. 

Returns the decimal representation in the database character set of the first character of string. 

Takes as its argument a string—or an expression that resolves to a string—in any character set, and returns an ASCII version of the string in the database character set. NonASCII characters are converted to the form 

Returns the arc sine of number. The argument number must be in the range of 1 to 1, and the function returns a value in the range of pi/2 to pi/2, expressed in radians. 

Returns the arc tangent of number. The argument number can be in an unbounded range and the function returns a value in the range of pi/2 to pi/2, expressed in radians. 

Returns the arc tangent of number1 and number2. The argument number1 can be in an unbounded range and the function returns a value in the range of pi to pi, depending on the signs of number1 and number2, expressed in radians. 

Converts a bit vector to its equivalent number. Each argument to this function represents a bit in the bit vector. This function takes as arguments any numeric data type, or any nonnumeric data type that can be implicitly converted to a number. Each expression must evaluate to 0 or 1. 

Computes an 

Returns the smallest integer greater than or equal to number. 

Returns the character having the binary equivalent to number as a string value in the database character set. 

Returns the first nonnull expression in the expression list. At least one expression must not be the literal 

Takes as its argument a string, or an expression that resolves to a string, in any data type, and returns a Unicode string in its fully normalized form in the same character set as the input. 

Returns string1 concatenated with string2. This function is equivalent to the concatenation operator. 

Converts a character string from one character set to another. 

Returns the cosine of number (an angle expressed in radians). 

Returns the hyperbolic cosine of number. 

Returns the current date in the session timezone, in a value in the Gregorian calendar. 

Returns the current date and time in the session timezone. If you omit precision, then the default is 6. 

Returns the value of the database timezone. The return type is a timezone offset (a character type in the format '+/ HH:MM') or a timezone region name. 

Compares expression to each search value one by one. If expression is equal to a search, then it returns the corresponding result. If no match is found, then it returns default. If default is omitted, then Oracle returns null. 

Takes as its argument a string in any data type and returns a Unicode string after decomposition in the same character set as the input. For example, an oumlaut code point will be returned as the "o" code point followed by an umlaut code point. 

Returns 

Extracts and returns the day from expression, which must be a valid ANSI date. 

Extracts and returns the hour from expression, which must be a valid ANSI datetime. 

Extracts and returns the minute from expression, which must be a valid ANSI datetime. 

Extracts and returns the month from expression, which must be a valid ANSI date. 

Extracts and returns the second from expression, which must be a valid ANSI datetime. 

Extracts and returns the abbreviation of the timezone from expression, which must be a valid ANSI datetime including a timezone. 

Extracts and returns the hour of the timezone from expression, which must be a valid ANSI datetime including a timezone. 

Extracts and returns the minute of the timezone from expression, which must be a valid ANSI datetime including a timezone. 

Extracts and returns the region of the timezone from expression, which must be a valid ANSI datetime including a timezone. 

Extracts and returns the year from expression, which must be a valid ANSI date. 

Returns largest integer equal to or less than number. 

Converts a timestamp value and a timezone to a 

Returns the greatest of the list of one or more expressions. 

Converts string containing hexadecimal digits to a raw value. 

Returns string, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. 

Searches string for substring using the input character set. The function returns an integer indicating the position of the first occurrence. Optionally, you can indicate the starting position for the search and the occurrence to search for. 

Searches string for substring using UC2 code points. The function returns an integer indicating the position of the first occurrence. Optionally, you can indicate the starting position for the search and the occurrence to search for. 

Searches string for substring using UC4 code points. The function returns an integer indicating the position of the first occurrence. Optionally, you can indicate the starting position for the search and the occurrence to search for. 

Searches string for substring using bytes instead of characters. The function returns an integer indicating the position of the first occurrence. Optionally, you can indicate the starting position for the search and the occurrence to search for. 

Searches string for substring using Unicode complete characters. The function returns an integer indicating the position of the first occurrence. Optionally, you can indicate the starting position for the search and the occurrence to search for. 

Returns the date of the last day of the month that contains date. 

Returns the least of the list of expressions. 

Returns the length of string. Length is calculated using characters as defined by the input character set. 

Returns the length of string. Length is calculated using characters as defined by the UC2 code point. 

Returns the length of string. Length is calculated using characters as defined by the UC4 code point. 

Returns the length of string. Length is calculated using bytes instead of characters. 

Returns the length of string. Length is calculated using Unicode complete characters. 

Returns the natural logarithm of number, where number is greater than 0. 

Returns the current date and time in the session timezone. 

Returns the logarithm, base number2, of number1. The base number1 can be any positive value other than 0 or 1 and number2 can be any positive value. 

Returns char, with all letters lowercase. 

Returns expression1, leftpadded to length number characters with the sequence of characters in expression2. If you do not specify expression2, then the default is a single blank. 

Removes from the left end of string all of the characters contained in 

Returns the remainder of number2 divided by number1. Returns number2 if number1 is 0. 

Returns number of months between dates date1 and date2. If date1 is later than date2, then the result is positive. If date1 is earlier than date2, then the result is negative. 

If number1 is not a number ( 

Returns the character having the binary equivalent to number as a string value in the national character set. 

Returns the date and time (given in timezone 1) converted in timezone (timezone2). 

Returns the date of the first weekday named by 

Returns a collation key for string—that is, a string of bytes used to sort strings. 

Returns string with the first letter of each word in uppercase and all other letters in lowercase. 

Returns string with all letters in lowercase. 

Returns string with all letters in uppercase. 

Compares expression1 and expression2. If they are equal, then the function returns null. If they are not equal, then the function returns expression1. You cannot specify the literal 

Converts number to an 

Converts number to an 

If expression1 is null, then 

If expression1 is not null, then 

Computes a hash value for a given expression. The expression argument determines the data for which you want to compute a hash value. The optional 

Returns number2 raised to the number1 power. The base number2 and the exponent number1 can be any numbers, but if number2 is negative, then number1 must be an integer. 

Converts raw to a character value containing its hexadecimal equivalent. 

Extends the functionality of the 

Extends the functionality of the 

Extends the functionality of the 

Extends the functionality of the 

Returns the remainder of number2 divided by number1. 

Returns string with every occurrence of 

Returns 

Returns expression1, rightpadded to length number characters with expression2, replicated as many times as necessary. If you do not specify expression2, then it defaults to a single blank. 

Removes from the right end of string all of the characters that appear in 

Converts a boolean to its standard string representation. The returned value is 

Returns a string concatenating the input values with the separator. Set the 

Calculates the distance between two strings, that is the number of insertions, deletions or substitutions required to transform string1 into string2. If one or both of the strings are null the distance will be the largest integer value (2147483647). Note that this function measures the distance in number of bytes and not in characters. As a consequence, strings stored using variablewidth character sets (e.g., UTF8) can cause counterintuitive results. It is recommended to convert these strings to a fixedwidth character set (AL16UTF16, for example) prior to passing them to this function. 

Calculates the distance between string1 into string2 (as described in the 

Finds the location of a substring within a specified string. 

Calculates the measure of agreement between two strings using JaroWinkler method. The value is between 0 (no match) and 1 (perfect match). If one or both strings are null, the result will be 0. 

Calculates the measure of agreement between two strings using JaroWinkler method, and returns a score between 0 (no match) and 100 (perfect match). If one or both strings are null, the result will be 0. 

Calculates the measure of agreement between two strings using the Dice coefficient similarity measure applied to the ngrams of the strings, and returns a score between 0 (no match) and 100 (perfect match). If one or both strings are null the result will be 0. The 

Returns a string with Latin (supplement, ExtendedA and ExtendedB) characters converted into their ASCII equivalents, and other (space and nonalphanumeric) characters eliminated. 

Converts a number to its standard string representation. 

Returns a portion of string, beginning at character position, 

Converts a timestamp to its standard string representation. 

Converts a string or a number to its standard string representation. 

Generic conversion to a string representation. 

Converts a UUID to its standard string representation. 

Get the next value of a sequence. Note that this function is not supported in enrichers. 

Returns the sign of number. The sign is 1 if n<0, 0 if n=0, and 1 if n>0. 

Returns the sine of number (an angle expressed in radians). 

Returns the hyperbolic sine of number. 

Returns a character string containing the phonetic representation of string. This function lets you compare words that are spelled differently, but sound alike in English. Note that phonetization methods such as 

Returns the square root of number. 

Computes a hash value for a given expression and returns it in a RAW value. The optional method lets you choose the hash algorithm (defaults to SHA1) in the following list: SHA1, SHA256, SHA384, SHA512 and MD5. This function requires Oracle version 12c or above. 

Returns a portion of string, beginning at character position, 

Returns a portion of string, beginning at character position, 

Returns a portion of string, beginning at character position, 

Returns a portion of string, beginning at character position, 

Returns a portion of string, beginning at character position, 

Returns the current date and time set for the operating system on which the database resides. 

Returns the system date, including fractional seconds and timezone, of the system on which the database resides. 

Returns the value of parameter associated with the context namespace. 

Extracts the UTC (Coordinated Universal Time—formerly Greenwich Mean Time) from a datetime value with timezone offset or timezone region name. 

Generates and returns a globally unique identifier (RAW value) made up of 16 bytes. 

Returns the tangent of number (an angle expressed in radians). 

Returns the hyperbolic tangent of number. 

Returns a doubleprecision floatingpoint number. 

Returns a singleprecision floatingpoint number. 

Converts expression to its string representation optionally using fmt and 

Converts expression to a CLOB (large string) 

Converts string to a date value. The 

Converts a character string to an 

Returns string with all of its singlebyte characters converted to their corresponding multibyte characters. 

Converts expression to a number value using the optional format model fmt and 

Returns string with all of its multibyte characters converted to their corresponding singlebyte characters. 

Converts string to timestamp value. The optional fmt specifies the format of string. 

Converts string to a 

Converts string to an 

Returns expression with all occurrences of each character in 

Removes from the left and right ends of string all of the characters contained in 

When expression is a date, returns expression with the time portion of the day truncated to the unit specified by the format model 

Takes as its argument a text literal or an expression that resolves to character data and returns it in the national character set. The national character set of the database can be either AL16UTF16 or UTF8. UNISTR provides support for Unicode string literals by letting you specify the Unicode encoding value of characters in the string. 

Returns string with all letters uppercase. 

Lets you construct 
Functions for PostgreSQL
The following functions are available when using PostgreSQL.
Function  Description 


Returns the absolute value 

Returns the inverse cosine 

Subtracts arguments, producing a symbolic result that uses years and months, rather than just days 

Concatenates input values—including null values—into an array. If the inputs are arrays, concatenates them into an array of one higher dimension (inputs must all have same dimensionality, and cannot be empty or null). 

ASCII code of the first character of the argument. For UTF8 returns the Unicode code point of the character. For other multibyte encodings, the argument must be an ASCII character. 

Returns the inverse sine. 

Returns the inverse tangent. 

Returns the inverse tangent of 

Returns the average (arithmetic mean) of all input values. 

Returns the bitwise AND of all nonnull input values, or null if none. 

Returns the number of bits in string. 

Returns the bitwise OR of all nonnull input values, or null if none. 

Returns true if all input values are true, otherwise false. 

Returns true if at least one input value is true, otherwise false. 

Removes the longest string consisting only of characters in characters (a space by default) from the start and end of string. 

Returns the cube root. 

Returns the nearest integer greater than or equal to argument. 

Returns the nearest integer greater than or equal to argument (same as 

Returns the number of characters in string. 

Returns the character with the given code. For UTF8 the argument is treated as a Unicode code point. For other multibyte encodings the argument must designate an ASCII character. The 

Returns the current date and time (changes during statement execution). 

The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. 

Concatenates the text representations of all the arguments. Null arguments are ignored. 

Concatenates all but the first argument with separators. The first argument is used as the separator string. Null arguments are ignored. 

Converts string to 

Converts string to the database encoding. The original encoding is specified by 

Converts string to 

Returns the cosine. 

Returns the cotangent. 

Returns the number of input rows for which the value of expression is not null. 

Returns the current date. 

Returns the current time of day. 

Returns the current date and time (at the beginning of current the transaction). 

Return value most recently obtained with 

Creates a range of dates. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Get subfield from a timestamp or an interval. The part to extract is defined by the text. 

Truncate timestamp or interval to the precision specified in the text. 

Decodes binary data from textual representation in string. Options for format are same as for 

Converts radians to degrees. 

Converts two strings to their Soundex codes and then reports the number of matching code positions. Since Soundex codes have four characters, the result ranges from zero to four, with zero being no match and four being an exact match. 

Returns the integer quotient of 

Returns a character string containing the phonetic representation of string using the Double Metaphone algorithm. This function returns the primary code for the string. See also 

Returns a character string containing the phonetic representation of string using the Double Metaphone algorithm. This function returns the secondary or alternate code for the string. See also 

Encodes binary data into a textual representation. Supported formats are: 

Equivalent to 

Returns the exponential. 

Returns the nearest integer less than or equal to argument. 

Formats the arguments according to 

Extract bit from string. 

Extract byte from string. 

The GREATEST function selects the largest value from a list of any number of expressions. 

Converts the first letter of each word to uppercase and the rest to lowercase. Words are sequences of alphanumeric characters separated by nonalphanumeric characters. 

Creates a range of integers. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Creates a range of bigints. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Returns a boolean indicating whether the range is empty. 

Tests for finite date, interval or timestamp (not +/ infinity). 

Aggregates values as a JSON array. 

Aggregates name/value pairs as a JSON object. 

Aggregates values as a JSON array. 

Aggregates name/value pairs as a JSON object. 

Adjust interval so 30day periods are represented as months. 

Adjust interval so 24hour periods are represented as days. 

Adjust interval using 

Return value most recently obtained with 

The LEAST function selects the smallest value from a list of any number of expressions. 

Returns the first n characters in the string. When n is negative, return all but last n characters. 

Returns the number of characters in string with an optional given encoding. The string must be valid in this encoding. 

Returns the Levenshtein distance between two strings, computed according to the cost specified for a character insertion, deletion, or substitution, respectively (you may set these values to 1). 

This function is an accelerated version of the 

Returns the natural logarithm. 

Returns the current time of day. 

Return the current date and time (at start of current transaction). 

Returns the logarithm in base 10. 

Convert string to lowercase. 

Returns a boolean indicating whether the lower bound of the range is inclusive. 

Returns a boolean indicating whether the lower bound of the range is infinite. 

Fills up the string to length length by prepending the characters 

Removes the longest string containing only characters from characters (a space by default) from the start of string. 

Create date from integer year, month and day fields. 

Create interval from years, months, weeks, days, hours, minutes and seconds fields. If a field is left empty, it defaults to zero. 

Create time from hour, minute and seconds fields. 

Create timestamp from year, month, day, hour, minute and seconds fields. 

Create timestamp with timezone from year, month, day, hour, minute and seconds fields; if timezone is not specified, the current timezone is used 

Returns the maximum value of expression across all input values. 

Calculates the MD5 hash of string, returning the result in hexadecimal. 

Returns a character string containing the phonetic representation of string using the Metaphone algorithm, with a maximum length equal to the integer argument. 

Returns the minimum value of expression across all input values. 

Returns the remainder of 

Advance sequence and return new value. 

Returns the current date and time (start of current transaction). 

The 

Creates a range of numerics. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Returns the number of nonnull values. 

Returns the number of null values. 

Returns the number of bytes in string. 

Overlays string with 

Returns the pi constant. 

Returns 

Returns the given string suitably quoted to be used as an identifier in an SQL statement string. Quotes are added only if necessary (i.e., if the string contains nonidentifier characters or would be casefolded). Embedded quotes are properly doubled. 

Returns the given string suitably quoted to be used as a string literal in an SQL statement string. Embedded single quotes and backslashes are properly doubled. Note that 

Returns the given string suitably quoted to be used as a string literal in an SQL statement string; or, if the argument is null, returns 

Converts degrees to radians. 

Returns a random value in the [0, 1] range. 

Returns the lower bound of range. 

Returns the smallest range which includes both of the given ranges. 

Returns the upper bound of range. 

Returns the captured substring(s) resulting from the first match of a POSIX regular expression to the string. flags contain one or more of the following values: i  caseinsensitive match, c  casesensitive match. 

Replaces the first substring matching a POSIX regular expression. flags contain one or more of the following values: i  caseinsensitive match, c  Casesensitive match. To replace all substrings, add 'g' to the flags. 

Splits the string using a POSIX regular expression as the delimiter. flags contain one or more of the following values: i  caseinsensitive match, c  casesensitive match. 

Repeats string the specified number of times. 

Replaces all occurrences in string of substring 

Returns the reversed string. 

Returns last n characters in the string. When n is negative, return all but first n characters. 

Rounds the number to the nearest integer or to int decimal places. 

Fills up the string to length length by appending the characters fill (a space by default). If the string is already longer than length, then it is truncated. 

Removes the longest string containing only characters from characters (a space by default) from the end of string. 

Returns the scale of the argument (the number of decimal digits in the fractional part). 

Converts a boolean to its standard string representation. The returned value is 

Explicitly cast its argument as a boolean. This can help the database or JDBC driver to infer the type of a bound parameter. 

Explicitly cast its argument as an integer. This can help the database or JDBC driver to infer the type of a bound parameter. 

Explicitly cast its argument as a numeric value (decimal or integer). This can help the database or JDBC driver to infer the type of a bound parameter. 

Explicitly cast its argument as a string (varchar). This can help the database or JDBC driver to infer the type of a bound parameter. 

Explicitly cast its argument as a timestamp. This can help the database or JDBC driver to infer the type of a bound parameter. 

Explicitly cast its argument as a UUID. This can help the database or JDBC driver to infer the type of a bound parameter. 

Returns a string concatenating the input values with the separator. Set the 

Calculates the number of insertions, deletions or substitutions required to transform string1 into string2. If one or both of the strings are null the distance will be the largest integer value (2147483647). 

Calculates the number of insertions, deletions or substitutions required to transform string1 into string2, and returns the Normalized value of Edit Distance between two Strings. The value is between 0 (no match) and 100 (perfect match). If one or both strings are null the result will be 0. 

Finds the location of a substring within a specified string. 

Calculates the measure of agreement between two strings using the Dice coefficient similarity measure applied to the ngrams of the strings, and returns a score between 0 (no match) and 100 (perfect match). If one or both strings are null the result will be 0. The 

Returns a string with Latin (supplement, ExtendedA, and ExtendedB) characters converted into their ASCII equivalents, and other (space and nonalphanumeric) characters eliminated. 

Converts a number to its standard string representation. 

Returns a portion of string, beginning at character position, 

Converts a timestamp to its standard string representation. 

Converts a string or a number to its standard string representation. 

Generic conversion to a string representation. 

Converts a UUID to its standard string representation. 

Get the next value of a sequence. Note that this function is not supported in enrichers. 

Sets the seed for subsequent random() calls (value between 1.0 and 1.0, inclusive). 

Set sequence’s current value. 

Set bit in string. 

Set byte in string. 

Returns the sign of the argument (1, 0, +1). 

Returns the sine. 

Returns a character string containing the phonetic representation of string. This function lets you compare words that are spelled differently, but sound alike in English. Note that phonetization methods such as 

Splits string on delimiter and return the element at position (counting from one). 

Returns the square root. 

Returns the current date and time (start of current statement). 

Return input values concatenated into a string, separated by delimiter. 

Returns the location of specified substring in string. 

Extracts a substring from string starting at from position and for count characters. 

Extracts from string a substring matching the pattern (a POSIX regular expression). 

Extracts from string a substring matching an SQL regular expression. 

Returns the sum of expression across all input values. 

Returns the tangent. 

Returns the current date and time (like 

Converts string to ASCII from another encoding (only supports conversion from LATIN1, LATIN2, LATIN9, and WIN1250 encodings). 

Convert the value (timestamp, interval, integer, real/double, numeric, string) to string according to the format. For more information about format patterns, see https://www.postgresql.org/docs/current/functionsformatting.html. 

Converts the string to date. for more information about format patterns, see https://www.postgresql.org/docs/current/functionsformatting.html. 

Converts number to its equivalent hexadecimal representation. 

Converts the string to numeric. For more information about format patterns, see https://www.postgresql.org/docs/current/functionsformatting.html. 

Converts the string to timestamp. For more information about format patterns, see https://www.postgresql.org/docs/current/functionsformatting.html. 

Returns the current date and time (start of current transaction). 

Any character in string that matches a character in the from set is replaced by the corresponding character in the to set. If from is longer than to, occurrences of the extra characters in from are removed. 

Truncates the number toward zero or to int decimal places. 

Creates a range of timestamps without timezone. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Creates a range of timestamps with timezone. Inclusivity is a string with an opening/closing square bracket or parenthesis indicating inclusiveness, with a default of 

Converts string to uppercase. 

Returns a boolean indicating whether the upper bound of the range is inclusive. 

Returns a boolean indicating whether the upper bound of the range is infinite. 

Returns the bucket number to which operand would be assigned in a histogram having count equalwidth buckets spanning the range b1 to b2; returns 0 or count+1 for an input outside the range. 

Returns the bucket number to which operand would be assigned given an array listing the lower bounds of the buckets; returns 0 for input less than the first lower bound; the thresholds array must be sorted, smallest first, or unexpected results will be obtained. 

Returns the concatenation of XML values. 
Functions for SQL server
The following functions are available when using SQL Server.
Function  Description 


A mathematical function that returns the absolute (positive) value of the specified numeric expression. 

A function that returns the angle, in radians, whose cosine is the specified float expression. 

This function returns the approximate number of unique nonnull values in a group. 

Returns the ASCII code value of the leftmost character of a character expression. 

A function that returns the angle, in radians, whose sine is the specified float expression. 

A function that returns the angle, in radians, whose tangent is a specified expression. 

Returns the angle—in radians—between the positive xaxis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions. 

This function returns the average of the values in a group. It ignores null values. 

This function returns the smallest integer greater than, or equal to, the specified numeric expression. 

This function searches for one character expression inside a second character expression, returning the starting position of the first expression if found. 

This function returns the checksum of the values in a group. 

Returns the item at the specified index from a list of values in SQL Server. 

Evaluates the arguments in order and returns the current value of the first expression that initially does not evaluate to 

This function concatenates two or more strings together. 

A mathematical function that returns the trigonometric cosine of the specified angle—measured in radians—in the specified expression. 

A mathematical function that returns the trigonometric cotangent of the specified angle—in radians—in the specified float expression. 

Returns the number of input rows for which the value of the expression is not null. 

This function adds a specified number value (as a signed integer) to a specified datepart of an input date value, and then returns that modified value. Note that datepart must be one of the following values, provided between quotes (e.g., 'year'): year, quarter, month, dayofyear, day, week, weekday, hour, minute, second, millisecond, microsecond, nanosecond. 

This function returns the count (as a signed integer value) of the specified datepart boundaries crossed between the specified startdate and enddate. Note that datepart must be one of the following values, provided between quotes (e.g., 'year'): year, quarter, month, dayofyear, day, week, weekday, hour, minute, second, millisecond, microsecond, nanosecond. 

This function returns a date value that maps to the specified year, month, and day values. 

This function returns a character string representing the specified datepart of the specified date. Note that datepart must be one of the following values, provided between quotes (e.g., 'year'): year, quarter, month, dayofyear, day, week, weekday, hour, minute, second, millisecond, microsecond, nanosecond. 

This function returns an integer representing the specified datepart of the specified date. Note that datepart must be one of the following values, provided between quotes (e.g., 'year'): year, quarter, month, dayofyear, day, week, weekday, hour, minute, second, millisecond, microsecond, nanosecond. 

This function returns a datetime2 value for the specified date and time arguments. The returned value has a precision specified by the precision argument. 

This function returns an integer that represents the day (day of the month) of the specified date. 

This function returns the corresponding angle, in degrees, for an angle specified in radians. 

This function returns an integer value measuring the difference between the 

This function returns the last day of the month containing a specified date, with an optional offset. 

Returns the exponential value of the specified float expression. 

Returns the largest integer less than or equal to the specified numeric expression. 

Returns a value formatted with the specified format and optional culture in SQL Server 2017. Use the 

Returns the current database system timestamp as a datetime value without the database timezone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running. 

Returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of its input in SQL Server. 

Returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0. 

Replaces NULL with the specified replacement value. 

Returns the left part of a character string with the specified number of characters. 

Returns the number of characters of the specified string expression, excluding trailing blanks. 

Returns the length of string. Length is calculated using characters as defined by the input character set. 

Returns the natural logarithm of the specified float expression. 

Returns the base10 logarithm of the specified float expression. 

Returns a character expression after converting uppercase character data to lowercase. 

Returns the string, leftpadded to length number characters with the sequence of characters in expression2. If you do not specify expression2, then the default is a single blank. 

Returns a character expression after it removes leading blanks. 

Returns the maximum value in the expression. 

Returns the minimum value in the expression. 

Returns an integer that represents the month of the specified date. 

Returns the Unicode character with the specified integer code, as defined by the Unicode standard. 

Creates a unique value of type 

Returns a null value if the two specified expressions are equal. 

Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types. 

Returns the constant value of pi. 

Returns the value of the specified expression to the specified power. 

Returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. 

Returns radians when a numeric expression, in degrees, is entered. 

Returns a pseudorandom float value from 0 through 1, exclusive. 

Replaces all occurrences of a specified string value with another string value. 

Repeats a string value a specified number of times. 

Returns the reverse order of a string value. 

Returns the right part of a character string with the specified number of characters. 

Returns a numeric value, rounded to the specified length or precision. 

Returns a character string after truncating all trailing spaces. 

Converts a boolean to its standard string representation. The returned value is 

Explicitly cast its argument as an integer value. This can help the database or JDBC driver to infer the type of a bound parameter. If the value provided is a valid number, rounds to the nearest integer; otherwise, returns 

Returns a string concatenating the input values with the separator. Set the 

Converts a timestamp to its standard string representation. 

Calculates the number of insertions, deletions or substitutions required to transform string1 into string2. If one or both of the strings are null, the distance will be the largest integer value (2147483647). 

Calculates the number of insertions, deletions or substitutions required to transform string1 into string2, and returns the normalized value of Edit Distance between two Strings. The value is between 0 (no match) and 100 (perfect match). If one or both strings are null the result will be 0. 

Finds the location of a substring within a specified string. 

Calculates the measure of agreement between two strings using the Dice coefficient similarity measure applied to the ngrams of the strings, and returns a score between 0 (no match) and 100 (perfect match). If one or both strings are null the result will be 0. The 

Returns a string with Latin (supplement, ExtendedA and ExtendedB) characters converted into their ASCII equivalents, and other (space and nonalphanumeric) characters eliminated. 

Converts a number to its standard string representation. 

Returns part of a character, binary, text, or image expression. 

Converts a timestamp to its standard string representation. 

Converts a string or a number to its standard string representation. 

Generic conversion to a string representation. 

Converts a UUID to its standard string representation. 

Get the next value of a sequence. Note that this function is not supported in enrichers. 

Returns the positive (+1), zero (0), or negative (1) sign of the specified expression. 

Returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression. 

Returns a fourcharacter (SOUNDEX) code to evaluate the similarity of two strings. 

Returns a string of repeated spaces. 

Returns the square root of the specified float value. 

Returns the square of the specified float value. 

Returns the statistical standard deviation of all values in the specified expression. 

Returns the statistical standard deviation for the population for all values in the specified expression. 

Returns character data converted from numeric data. 

Concatenates the values of string expressions and places separator values between them. The separator is not added at the end of string. 

Escapes special characters in texts and returns text with escaped characters. 

Splits the character expression using specified separator. 

The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. 

Returns part of a character, binary, text, or image expression in SQL Server. 

Returns the sum of all the values, or only the 

Returns a 

Returns the tangent of the input expression. 

Returns the string provided as a first argument after some characters specified in the second argument are translated into a destination set of characters. 

Removes the characters (by default a space) from the start or end of the string expression. 

Returns the integer value, as defined by the Unicode standard, for the first character of the input expression. 

Returns a character expression with lowercase character data converted to uppercase. 

Returns the statistical variance of all values in the specified expression. 

Returns the statistical variance for the population for all values in the specified expression. 

Returns an integer that represents the year of the specified date. 