SQL_QUERY_CASE_SENSITIVE_LOCATE

Description:

This property enables or disables case-sensitive matching for the SQL LOCATE function.

Values and behavior:

Yes: disables case-sensitive matching for the SQL LOCATE function.

No: enables case-sensitive matching for the SQL LOCATE function.

Default value:

yes

Scope:

Application

Comes into effect:

This is a hot deployed property. The administrator can change its value, and it will be applied instantly. No BI Server restart is required.

Environment:

Applicable in all environments.