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@...