> select * from TB_TEST where COLUMN_1 NOT LIKE '__________';
>
> If your column was longer than 10 chars you should add '%' to the
> emd of the pattern.

yes..it is working. but how does it work?