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

although itz more related to SQL.. am using FB 1.5.2

i need something like this:

select * from TB_TEST
where Length(String(COLUMN_1)) < 10;

COLUMN_1 = Varchar(10);

any help is appreciated:)

thanx

feroz