That statement would give me inaccurate results. Text1...., these are company names and I need to use NOT LIKE statement to minimize the margin or error.

how cum you get inaccurate results?

since ur company names are 'text1', 'text2' and 'text3'. You can bring all these straight('text1', 'text2' and 'text3') into a NOT IN clause.

LIKE statement will be useful when you want to retrieve records which contain values %TEST%...