On 27 Jan 2005 at 8:08, hi_feroz wrote:

>how to write select statement to fecth the records where the length of
>value of a string field is < 10?

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.
--
SY, Dimitry Sibiryakov.