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

Like this post? Share on: TwitterFacebookEmail


Related Articles


Author

Firebird Community

Published

Category

Gems from Firebird Support list

Tags