Subject Re: [firebird-support] Func abs() in FB
Author Hannes Streicher
Guten Tag mugi yanto,

am Freitag, 11. April 2008 um 10:47 schrieben Sie:

> 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?

you are testing for less then zero already so a simple negation will
do the trick as well

UPDATE xtable
SET qty=-qty
WHERE qty<0;

Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...