hi_feroz wrote:

>
> 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:)

Check out the "strlen" function in the ib_udf UDF library which comes
with every Firebird installation.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com