Subject String length, was Re: How to cast a float?
Author Helen Borrie
At 05:45 AM 13/09/2004 +0000, you wrote:

>BTW, does FB support the LENGTH function in SQL? I.e for a char or
>varchar column called "my_string", something like:
>select my_pk from my_table where length(my_string) > 2

You'd need the UDF strlen():

select my_pk from my_table
where strlen(MyVarcharCol) > 2

Grab the SQL for the function declaration out of ib_udf.sql and change the
length of the input parameter declaration to be long enough to accommodate
the longest string that is likely to be passed to it.