Filtering on String Values

 

The Filtering on String Values VLDB property determines whether filters consider trailing spaces in attribute elements. This can affect the data that is restricted when filtering data. This VLDB property has the following options:

• Do not trim trailing spaces: Attribute elements that include trailing spaces can be returned as separate attribute elements when filtering on the attribute. For example, an attribute has two attribute elements, one with the description information "South" and the other with the description information "South " which has an extra trailing space at the end. By selecting this option, these attribute elements can be returned as separate attribute elements when filtering on the attribute.
• Trim trailing spaces: Attribute elements that include trailing spaces are not returned as separate attribute elements when filtering on the attribute. Instead, any trailing spaces are ignored. For example, an attribute has two attribute elements, one with the description information "South" and the other with the description information "South " which has an extra trailing space at the end. By selecting this option, only a single South attribute element is returned when filtering on the attribute. Since trailing spaces are commonly viewed as an error in the data, it is recommended that you use this default Trim trailing spaces option to ignore any trailing spaces.

Levels at Which You Can Set This

Project only