I have a need to find if a string exists between 2 strings, but the string may or may not be on the same line.
I am looking for a "delete" with a "where"
so here is an example:
Delete from table where name = bob;
or
Delete from table
where name = bob;
If there is not 'where' between the 'delete' and ';' I need to find that. I do not need the string between the strings, just if the work "where" exists.