---
title: "I_SQL_SELECT_SCALAR"
description: "The Excel formula I_SQL_SELECT_SCALAR composes and executes a SQL select statement, returning the single column, single row result."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/docs/invantive-control-for-excel/formulas/generic/i-sql-select-scalar
original: https://documentation.invantive.eu/en/docs/invantive-control-for-excel/formulas/generic/i-sql-select-scalar
updated: 2026-04-17T00:00:00Z
license: https://documentation.invantive.eu/en/
---

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.

## Release Notes

- [Invantive Control for Excel](/en/release-notes/products?product=invantive-control-for-excel)
  - [26.0 to 27.0](/en/release-notes/products?product=invantive-control-for-excel&step=26.0-to-27.0)
  - [25.0 to 26.0](/en/release-notes/products?product=invantive-control-for-excel&step=25.0-to-26.0)

