Subject Re: [firebird-support] Func abs() in FB
Author Helen Borrie
At 06:47 PM 11/04/2008, you wrote:
>Dear All,
>Usually in mysql i use the syntax :
>UPDATE xtable
>SET qty=ABS(qty)
>WHERE qty<0;
>What I should type that command in FB 1.5?

the same - but in Fb 1.5 it is an external function (UDF) so you must declare it in the database in order to use it. You will find the declaration script in the /udf/ directory, in ib_udf.sql.