I am using an ODBC enabled tool that requires an ODBC version x compliant driver.  What version of ODBC does Relativity support?

What version of ODBC does Relativity support?

Relativity is ODBC 2.0 compliant.  However, it does implement some SQL grammar and scalar functions from later versions of the ODBC standard.

The following SQL statements are supported by Relativity:

CREATE INDEX
CREATE TABLE
CREATE VIEW
DELETE
DROP TABLE
DROP VIEW
INSERT
SELECT
UPDATE

The following SQL clauses and predicates are also supported:

AVG
COUNT
MAX
MIN
SUM
BETWEEN
HAVING
EXISTS
IN
UNION
UNION ALL
GROUP BY
ORDER BY

Additionally the following ODBC scalar functions are supported:

CONCAT
CONVERT
CURDATE
CURTIME
DATABASE
DAYOFMONTH
DAYOFWEEK
IF
LCASE
LEFT
LENGTH
LOCATE
LTRIM
MOD
MONTH
NULL
QUARTER
RIGHT
RTRIM
SUBSTRING
UCASE
USER
YEAR

For more information regarding Relativity's supported SQL grammar, please see the Relativity Data Client help file.

For detailed information about the arguments and return values of scalar functions, see Appendix F of the Microsoft ODBC 2.0 SDK Programmer's Reference.