I_SQL_SELECT_SCALAR
The Excel formula I_SQL_SELECT_SCALAR composes and executes a SQL select statement, returning the single column, single row result.
Parameters:
fieldName: the name of the column to select.tableName: the name of the table.whereClause: the where clause for the statement.orderByClause: the order instructions.postFix: postfix for the statement.valueNoValue: value to return when no row was retrieved.valueToomanyValues: value to return when more than one row was retrieved.process: Excel boolean indicating whether to actually execute the statement.
Returns: the single column, single row result when made available.