SQL Server Native Client Comparability for IRowsetFind

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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)