comparability-for-irowsetfind.md

title	Comparability for IRowsetFind
ms.date	03/04/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology
ms.topic	reference
helpviewer_keywords	IRowsetFind comparability [ODBC]
ms.assetid	7d148b56-9bbe-4e55-b31f-43f115705402
author	markingmyname
ms.author	maghan
ms.custom	seo-dt-2019
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Comparability for IRowsetFind

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

For date/time types only, IRowsetFind supports the following comparisons:

• LT

• LE

• EQ

• GE

• GT

• NE

• IGNORE

If any other comparison is attempted, DB_E_BADCOMPAREOP is returned. This is consistent with the OLE DB specification.

See Also

Date and Time Improvements (OLE DB)