Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

EXPRTYPE function [Miscellaneous]

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

EXPRTYPE( string-expression, integer-expression )

string-expression    A SELECT statement. The expression whose data type is to be queried must appear in the select list. If the string is not a valid SELECT statement, NULL is returned.

integer-expression    The position in the select list of the desired expression. The first item in the select list is numbered 1. If the integer-expression value does not correspond to a SELECT list item, NULL is returned.

• SQL Data Types
• sa_describe_query system procedure

• SQL/2003    Vendor extension.

The following statement returns smallint when executed against the SQL Anywhere sample database.

SELECT EXPRTYPE( 'SELECT LineID FROM SalesOrderItems', 1 );