Functions

Returns the absolute value of a numeric expression.

Returns the arc-cosine, in radians, of a numeric expression.

Returns a selected argument from a list of arguments.

Returns elements of a specific data type.

Creates an unbounded, single-dimensional array from the specified expression for each group where the array element type is identical to the specified expression.

Returns the maximal number of elements in the array.

Returns the integer ASCII value of the first byte in a string-expression.

Returns the arc-sine, in radians, of a number.

Returns the arc-tangent, in radians, of the ratio of two numbers.

Computes the average, for a set of rows, of a numeric expression or of a set of unique values.

Decodes data using the MIME base64 format and returns the string as a LONG VARCHAR.

Encodes data using the MIME base64 format and returns it as a 7-bit ASCII string.

Returns the hexadecimal equivalent of a binary string.

Returns the bit-wise AND of the specified expression for each group of rows.

Returns the number of bits stored in the array.

Returns the bit-wise OR of the specified expression for each group of rows.

Returns a sub-array of a bit array.

Returns the bit-wise XOR of the specified expression for each group of rows.

Inserts a string into another string at a position specified in bytes.

Returns the number of bytes in a string.

Returns the position of one BYTE string within another.

Replaces a string with another string, and returns the new results.

Deletes multiple bytes from one string and replaces them with different bytes.

Returns a substring of a string. The substring is calculated using bytes, not characters.

Returns the highest number of any array element that has been assigned a value, including NULL.

Returns the value of an expression converted to a supplied data type.

Returns the first integer that is greater or equal to a given value. For positive numbers, this is known as rounding up.

Returns the character with the ASCII value of a number.

Returns the number of characters in a string.

Returns the position of one string in another.

Returns the first non-NULL expression from a list. This function is identical to the ISNULL function.

Allows you to compare two character strings based on alternate collation rules.

Compresses the string and returns a value of type LONG BINARY.

Indicates if a column is a source of conflict for an UPDATE being performed against a consolidated database in a SQL Remote environment.

Returns the value of the given property. Allows an optional property-specific string parameter to be specified.

Returns the value of a given connection property as a string.

Returns an expression converted to a supplied data type.

Returns the correlation coefficient of a set of number pairs.

Returns the cosine of the angle in radians given by its argument.

Returns the cotangent of the angle in radians given by its argument.

Counts the number of rows in a group depending on the specified parameters.

Counts the number of rows in a group depending on the specified parameters.

Returns a count of the number of bits set to 1 (TRUE) in the array.

Returns the population covariance of a set of number pairs.

Returns the sample covariance of a set of number pairs.

Converts strings between character sets.

Computes the relative position of one value among a group of rows.

Returns the length, in bytes, of the underlying storage for the result of an expression.

Converts the expression into a date, and removes any hours, minutes, or seconds.

Returns a TIMESTAMP or TIMESTAMP WITH TIME ZONE value produced by adding a date part to its argument.

Returns the interval between two dates.

Returns a string representing a date expression in the specified format.

Returns the name of the specified part (such as the month June) of a TIMESTAMP or TIMESTAMP WITH TIME ZONE value, as a character string.

Returns a portion of a TIMESTAMP or TIMESTAMP WITH TIME ZONE value.

Converts an expression into a TIMESTAMP value.

Returns the day of the month of its argument as an integer between 1 and 31.

Returns the name of the day of the week from a date.

Manipulates a TIMESTAMP or returns the number of days between two TIMESTAMP values.

Returns the value of the given property. Allows an optional property-specific string parameter to be specified.

Returns the database ID number.

Returns the name of a database with a given ID number.

Returns the value of the specified database property.

Decompresses the string and returns a LONG BINARY value.

Decrypts the string using the supplied key and returns a LONG BINARY value.

Converts a number from radians to degrees.

Calculates the rank of a value in a partition. For tied values, the DENSE_RANK function does not leave gaps in the ranking sequence.

Returns the difference in the SOUNDEX values between the two string expressions.

Returns a number from 1 to 7 representing the day of the week of a date, where Sunday=1, Monday=2, and so on.

Encrypts the specified value using the supplied encryption key and returns a LONG BINARY value.

Returns the line number of the procedure or batch where the error occurred that invoked the CATCH block of a TRY...CATCH statement.

Returns the message text of the error that invoked the CATCH block of a TRY...CATCH statement.

Returns the name of the procedure within which the error that caused the exception handler to run occurred.

Returns the SQLCODE of the error that invoked the error handler.

Returns the SQLSTATE of the error that invoked the error handler.

Returns a calling sequence stack trace for the error that invoked the error handler.

Provides the error message for the current error, or for a specified SQLSTATE or SQLCODE value.

Returns selectivity estimates as a percentage calculated by the query optimizer, based on specified parameters.

Provides the source for selectivity estimates used by the query optimizer.

Specifies when an event handler is triggered.

Lists the possible parameters for EVENT_CONDITION.

Provides context information for event handlers.

Returns the result of the base of natural logarithms e raised to the power of the given argument.

Returns selectivity estimates as a percentage calculated by the query optimizer, based on specified parameters.

Returns the optimization strategy of a SQL statement as a plain text string.

Returns a string that identifies the data type of an expression.

Returns the value of the given database server property. Allows an optional property-specific string parameter to be specified.

Returns a date part from a TIMESTAMP expression.

Returns values from the first row of a window.

Returns the largest integer not greater than the given number.

Returns the value (1 or 0) of a specified bit in a bit array.

Allocates values to an AUTOINCREMENT column. This is an alternative to using AUTOINCREMENT to generate numbers.

Returns the current year, month, day, hour, minute, second, and fraction of a second.

Returns the plan optimization strategy of a SQL statement in XML format, as a string.

Returns the greater of two parameter values.

Identifies whether a column in a GROUP BY operation result set is NULL because it is part of a subtotal row, or NULL because of the underlying data.

Returns the specified value in hashed form.

Returns the LONG BINARY equivalent of a hexadecimal string.

Returns the decimal integer equivalent of a hexadecimal string.

Returns the hour component of a TIMESTAMP value.

Manipulates a TIMESTAMP or returns the number of hours between two TIMESTAMP values.

Decodes special character entities that appear in HTML literal strings.

Encodes special characters within strings to be inserted into HTML documents.

Returns the body of the HTTP request in binary form. For example, in a POST request, this is the raw POST data.

Decodes HTTP encoded strings. This is also known as URL decoding.

Encodes strings for use with HTTP. This is also known as URL encoding.

Returns the value of an HTTP request header.

Returns the value of an HTTP response header.

Returns the value of an HTTP variable.

Generates integer values, starting at 1, for each successive row in a query.

Evaluates whether one expression is NULL and returns a value.

Returns selectivity estimates from the index as a percentage calculated by the query optimizer, based on specified parameters.

Inserts a string into another string at a specified position.

Returns a string containing the hexadecimal equivalent of an integer.

Tests if a string argument can be converted to a date.

Determines if a string is encrypted using the ENCRYPT function and the specified key.

Returns the first non-NULL expression from a list. This function is identical to the COALESCE function.

Determines if a string argument is a valid number.

Returns values from the last row of a window.

Converts all characters in a string to lowercase.

Returns multiple characters from the beginning of a string.

Returns the number of characters in the specified string.

Returns the lesser of two parameter values.

Returns a delimited list of values for every row in a group.

Returns the position of one string within another.

Returns the natural logarithm of a number.

Returns the base 10 logarithm of a number.

Converts all characters in a string to lowercase.

Removes leading blanks from the string.

Returns the maximum expression value found in each group of rows.

Computes the median of a numeric expression for a set of rows.

Returns the microsecond component of a TIMESTAMP expression.

Returns the millisecond component of a TIMESTAMP expression.

Returns the minimum expression value found in each group of rows.

Returns the minute component of a TIMESTAMP value.

Manipulates a TIMESTAMP or returns the number of minute boundaries between two TIMESTAMP values.

Returns the remainder when one whole number is divided by another.

Returns the month of the given date.

Returns the name of the month from a date.

Manipulates a TIMESTAMP or returns the number of month boundaries between two TIMESTAMP values.

Returns an NCHAR string containing one character whose Unicode code point is given in the parameter, or NULL if the value is not a valid code point value.

Generates a UUID (Universally Unique Identifier) value. A UUID is the same as a GUID (Globally Unique Identifier).

Returns an identifying number for the next connection.

Returns an identifying number for a database.

Returns the next HTTP header name.

Returns the next HTTP response header name.

Returns the next HTTP variable name.

Returns the next header key in a SOAP request header.

Returns the current date and time as a TIMESTAMP value. The accuracy is limited by the accuracy of the system clock.

Provides an abbreviated CASE expression by comparing expressions.

Generates numbers starting at 1 for each successive row in the results of the query. The NUMBER function is primarily intended for use in SELECT lists.

Returns an integer representing the starting position of the first occurrence of a pattern in a string.

For any row X, defined by the function's arguments and ORDER BY specification, the PERCENT_RANK function determines the rank of row X - 1, divided by the number of rows in the group.

Returns the numeric value PI.

Returns the long plan optimization strategy of a SQL statement, as a string.

Calculates one number raised to the power of another.

Returns the value of the specified database server property as a string.

Returns a description of a property.

Returns whether or not you can maintain historical data for the specified database server property by storing its tracked values.

Returns the name of the property with the supplied property ID for the specified connection level.

Returns the property number of the property with the supplied property-name.

Returns a number indicating the quarter of the year from the supplied TIMESTAMP expression.

Converts a number from degrees to radians.

Returns a random number in the interval 0 to 1, with an optional seed.

Calculates the value of a rank in a group of values. For ties, the RANK function leaves a gap in the ranking sequence.

Reads data from the specified file on the client computer.

Reads data from the specified file on the server and returns the full or partial contents of the file as a LONG BINARY value.

Extracts substrings from strings using regular expressions.

Computes the average of the independent variable of the regression line.

Computes the average of the dependent variable of the regression line.

Returns an integer that represents the number of non-NULL number pairs used to fit the regression line.

Computes the y-intercept of the linear regression line that best fits the dependent and independent variables.

Computes the coefficient of determination (also referred to as R-squared or the goodness of fit statistic) for the regression line.

Computes the slope of the linear regression line fitted to non-NULL pairs.

Returns the sum of squares of the independent expressions used in a linear regression model. The REGR_SXX function can be used to evaluate the statistical validity of a regression model.

Returns the sum of products of the dependent and independent variables. The REGR_SXY function can be used to evaluate the statistical validity of a regression model.

Returns values that can evaluate the statistical validity of a regression model.

Returns the remainder when one whole number is divided by another.

Concatenates a string a specified number of times.

Replaces a string with another string, and returns the new results.

Concatenates a string a specified number of times.

Returns the reverse of a character expression.

Returns a rewritten SELECT, UPDATE, or DELETE statement.

Returns the rightmost characters of a string.

Rounds the numeric-expression to the specified integer-expression amount of places after the decimal point.

Returns a sequence of ( field name data type, ... ) pairs named fields.

Assigns a unique number to each row. Use this function instead of the NUMBER function.

Returns an UNSIGNED BIGINT value that uniquely identifies a row within a table.

Removes trailing blanks from the string.

Returns the seconds value of the TIMESTAMP argument.

Manipulates a TIMESTAMP or returns the number of second boundaries between two TIMESTAMP values.

Digitally signs a message.

Digitally verifies a message.

Sets the value of a specific bit in a bit array.

Creates a bit array where specific bits, corresponding to values from a set of rows, are set to 1 (TRUE).

Returns the sign (positive or negative) of the given number.

Returns a number indicating the similarity between two strings.

Returns the sine of a number.

Returns a SOAP header entry, or an attribute value for a header entry of the SOAP request.

Generates sort key values. That is, values that can be used to sort character strings based on alternate collation rules.

Returns a number representing the sound of a string.

Returns a specified number of spaces.

Returns either Watcom SQL or Transact-SQL, to indicate the SQL dialect of a statement.

Returns the conformity of a given SQL statement to a specified standard such as the ANSI/ISO SQL Standard.

Returns the square root of a number.

Returns information about the stack trace for the current statement.

An alias for STDDEV_SAMP.

Computes the standard deviation of a population consisting of a numeric-expression, as a DOUBLE.

Computes the standard deviation of a sample consisting of a numeric-expression, as a DOUBLE.

Returns the string equivalent of a number.

Concatenates one or more strings into one large string.

Converts a string value to a unique identifier (UUID or GUID) value.

Deletes multiple characters from one string and replaces them with another string.

Returns a substring of a string.

Returns the total of the specified expression for each group of rows.

Returns the numeric user ID for the specified user name.

Returns the user name for the specified user ID.

Returns a TIMESTAMP WITH TIME ZONE value that is converted from its original time zone offset to the specified time zone offset.

Returns the current date, time, and time zone offset of the database server using the system clock.

Returns the tangent of a number.

Returns a 16-byte binary pointer to the specified column. This feature is provided solely for compatibility with Transact-SQL and its use is not recommended.

Converts character data from any supported character set into the CHAR character set for the database.

Converts character data from any supported character set into the NCHAR character set.

Converts a TIMESTAMP value to a TIME STAMP WITH TIME ZONE value using the specified time zone offset.

Returns the current date as a DATE value.

Returns statements on the stack of the most recent exception (error) that occurred during a stored procedure, trigger, or custom function execution.

The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. This function is used by SQL Central to generate a graphical plan for a query using tracing data.

Rewrites a Watcom SQL statement in the Transact-SQL dialect.

Changes the declared type of a geometry expression to a subtype. This function is for use with spatial data.

Removes leading and trailing blanks from a string.

Returns an implicitly bounded array that consists of a specified number of elements in an array.

Truncates a number at a specified number of places after the decimal point.

Compares two TIMESTAMP values and returns whether they are the same.

Converts all characters in a string to uppercase.

Returns an integer containing the Unicode code point of the first character in the string, or NULL if the first character is not a valid encoding.

Converts a string containing characters and Unicode escape sequences to an NCHAR string.

Converts all characters in a string to uppercase.

Returns the numeric user ID for the specified user name.

Returns the user name for the specified user ID.

Converts a unique identifier value (UUID, also known as GUID) to a string value.

Computes the statistical variance of a population consisting of a numeric-expression, as a DOUBLE.

Computes the statistical variance of a sample consisting of a numeric-expression, as a DOUBLE.

Returns 1 if a user-defined variable exists with the specified name. Returns 0 if no such variable exists.

An alias for VAR_SAMP.

Rewrites a Transact-SQL statement in the Watcom SQL dialect. This can be useful when converting existing Adaptive Server Enterprise stored procedures into Watcom SQL syntax.

Manipulates a TIMESTAMP or returns the number of weeks between two TIMESTAMP values.

Creates and writes to a file on the client computer.

Generates a forest of XML elements from a collection of XML values.

Produces a forest of XML elements.

Produces an XML element within a query.

Generates a forest of XML elements.

Generates an XML value based on an XQuery constructor.

Returns the year component of the TIMESTAMP argument.

Manipulates a TIMESTAMP or returns the number of years between two TIMESTAMP values.

Returns a date value corresponding to the given year, month, and day of the month. Arguments are INTEGER values from -32768 to 32767.