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’