SQL & PL/SQL

Hello everyone,

I'm trying to use dbms_lob.substr on a clob column in one of my tables. I'm searching the table for a particular phrase, which should be the first two words in this column. Any row that has that phrase should be returned. However, when I run the script, I get only rows where the ONLY words in the entire column are the two words. Here's an example

| ID | | Name | | Information |
| 1 | | Jorge | | Terminated for negligence |
| 2 | | Stephanie | | Terminated for ... ? |

I need the script to return both of those rows.

Here's my script:

WHERE

dbms_loc.substr("EMPLOYEE"."COMMENTS", 15, 1)='Terminated for'

Thanks,

Joe