Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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/2003 Vendor extension.
The following statement returns
smallint when executed against the SQL Anywhere sample database.
SELECT EXPRTYPE( 'SELECT LineID FROM SalesOrderItems', 1 );
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|