Two types of substring comparison tests are offered, as follows:
- Find a constant within a field value. For example, you can search
the value in a 6-byte field for the character constant C'OK'. If the
field value is, for example, C'**OK**' or C'****OK', the relational
condition is true; if the field value is C'**ERR*', the relational
condition is false.
- Find a field value within a constant. For example, you can search
the character constant C'J69,L92,J82' for the value in a 3-byte field.
If the field value is C'J69', C'L92', or C'J82', the relational condition
is true; if the field value is C'X24', the relational condition is
false. Note that the comma is used within the constant to separate
the valid 3-character values; any character that will not appear in
the field value can be used as a separator in the constant.