From ib_udf.sql:

/*****************************************
* s t r l e n
*****************************************
* Functional description:
* Returns the length of a given string.
*****************************************/
DECLARE EXTERNAL FUNCTION strlen
CSTRING(32767)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';

You'll need to load the UDFs into your database though ... You might want to look through that SQL file - there are a lot of other handy functions in there too. Also, see fbudf.sql.

Regards,

Eddie

----- Original Message -----
From: nadabadan
To: firebird-support@yahoogroups.com
Sent: Wednesday, March 10, 2004 5:15 PM
Subject: [firebird-support] size of the field


Hi,
Is there a strlen statement in FireBird SQL to get the size of a
field? For example...

If i do "INSERT INTO TABLE1( field1 ) VALUES( "ABC" );

then is something like

SELECT strlen(field) from TABLE1; ?

Thanks.

Nada


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.611 / Virus Database: 391 - Release Date: 3/6/2004

[Non-text portions of this message have been removed]