> -----Original Message-----
> Is there any function like ABS in Firebird that I can use in
> order to calculate the absolute value of a number?

Yes, its in ib_udf, which is part of standard install.

>
> I try to use it as ABS and it does not exists.

Have you declared the UDF within your database?


DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';


Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum