On 27 Jan 2005 at 10:12, hi_feroz wrote:

>> select * from TB_TEST where COLUMN_1 NOT LIKE '__________';
>
>yes..it is working. but how does it work?

Find a good SQL guide and read about "LIKE" operator.
--
SY, Dimitry Sibiryakov.