ANY (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Compares a scalar value with a single-column set of values. For more information, see SOME | ANY (Transact-SQL).
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Compares a scalar value with a single-column set of values. For more information, see SOME | ANY (Transact-SQL).