Subject Re: [firebird-support] Absolute value
Author Ivan Prenosil
> Is there an absolute value function built into Firebird? If not what
> would be the best way to implement one? Without building a stored
> procedure.

SELECT CASE WHEN MyField<0 THEN -MyField ELSE MyField END
FROM MyTab

Ivan
http://www.volny.cz/iprenosil/interbase/