| == | Equals |
| != | Not equals |
| like | LHS contains a match for RHS |
| !like | LHS doesn’t contain a match for RHS |
| contains | RHS occurs as a subsequence of LHS |
| !contains | RHS doesn’t occur in LHS |
| startswith | RHS is an initial subsequence of LHS |
| !startswith | RHS isn’t an initial subsequence of LHS |
| endswith | RHS is a closing subsequence of LHS |
| !endswith | RHS isn’t a closing subsequence of LHS |
Reference: https://docs.microsoft.com/en-us/sccm/core/servers/manage/cmpivot