Using STRICT to Control Case and Trailing Space Behavior for Queries

Administration Guide > TDV Configuration Options > Configuring Case Sensitivity and Trailing Spaces Settings > Using STRICT to Control Case and Trailing Space Behavior for Queries

If the TDV and data source settings do not match for case sensitivity or trailing spaces, use the STRICT option in any query that includes one of these operators:

• DISTINCT

• UNION

• INTERSECT

• EXCEPT