Will your company name change now and then?

say sometime you might user TEST1, TEST2 and TEST3.
sometime TEST2, TEST3 and TEST4 ???

In that case you can have a company master which stores all the company appearing in NOT IN clause. Where you can use an NOT IN or NOT EXIST caluse.

HTH