Article - CS225012

Integrity query using 'Contains' clause does not return items with underscores.

Modified: 11-Dec-2015   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 4.6/ 8.6 to 10.8
  • MS SQL Databases only

Description

  • Using a Contains condition within an Integrity query, the query does not return expected results when the text field being searched contains underscore characters
    • For example, if the field contents is 'Integrity_Server_Tango7X' and your contains query searches for 'TangoX', the item is not returned
This is a printer-friendly version of Article 225012 and may be out of date. For the latest version click CS225012