I am struggling with the proper syntax to search for a field value within a large set of text. I am using Embarcadero Rapid SQL.

I know how to search by using the like function (ex: like '%string or text here%'). But what if I want to search for the value of a certain field that is mapped to the table based on an ID number where the a large amount of text is documented and the value of a filed can be within there?