The two containment operators (CONTAINS and ~CONTAINS) are designed to be used with string values. If the first string contains the second string, the result of the operation is TRUE. Otherwise, the result of the operation is FALSE.
The "CONTAINS" operator is case-sensitive. The "~CONTAINS" operator is not case-sensitive.
Examples:
'SiteMinder' CONTAINS 'EMI'
Result = FALSE
'SiteMinder' ~CONTAINS 'EMI'
Result = TRUE
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |