CASE_SENSITIVE (SELECT Option)
CASE_SENSITIVE forces string comparisons to be case-sensitive. This option overrides the TDV Server’s Case Sensitivity configuration setting (under TDV Server > SQL Engine > SQL Language).
If CASE_SENSITIVE is set to FALSE or not specified, TDV Server’s Case Sensitivity configuration setting determines how string comparisons are evaluated.
Note: When SELECT options are specified as part of a subquery or subselect, they might not affect the root-level query execution plan.
Operator
SELECT
Syntax
case_sensitive[={"TRUE"|"FALSE"}]
Example
SELECT {OPTION case_sensitive="TRUE"} *
FROM table1
WHERE column1 = ’FOO’