I need to search for a pattern in a string field which contains an email and an additional comment. An example is the following:

```
Dear XXX: We are sorry to inform you that your 
application has been put on hold because YYY. 

Additional comments: this application was not held for ZZZ.

```

The pattern I am looking for is "ZZZ" in the email body. But not in the comments. If I just do `field like 'ZZZ'`, I will be picking up this record, which is not what I want. Is there a way to carry out the search accurately in this case?

Note that a subset of the records have the field structured this way, others may not contain this structure (i.e. no `Additional comments:`. The bold letters mark the structure of the subset.