Darin Amos wrote:
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.
Ivan Prenosil answers:
SELECT CASE WHEN MyField<0 THEN -MyField ELSE MyField END
FROM MyTab