IGNORE_TRAILING_SPACES (SELECT Option)

IGNORE_TRAILING_SPACES causes comparisons to ignore trailing spaces. This option overrides the TDV Server’s Ignore Trailing Spaces configuration setting (under TDV Server > SQL Engine > SQL Language).

If IGNORE_TRAILING_SPACES is set to FALSE or not specified, TDV Server’s Ignore Trailing Spaces 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

ignore_trailing_spaces[={"TRUE"|"false"}]

Example

SELECT {OPTION ignore_trailing_spaces="false"} * 

	FROM table1

	WHERE column1 = ’FOO  ’