Re: Math in Informix SQL

Well, in 6.00 and later versions, at any rate, the mathematical operators are built-in: ABS, MOD, POW, ROOT, ROUND, SQRT, TRUNC, EXP, LOGN, LOG10, HEX, COS, SIN, TAN, ASIN, ACOS, ATAN, ATAN2 Try them in your version; they were present before they were documented. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: lanny@terren.com (V. Lanny Rosicky) >Date: Thu, 04 Apr 96 18:14:11 GMT >X-Informix-List-Id: <news.22806> > >Is it possible that I cannot locate an arithmetic operator for exponentiation >in SQL ? > >I need to do square and root. The solution for square was to wright a stored >procedure and access it as a function i.e. select pow2(a+b) from table. But >I am stuck with square root.