Re: Math in Informix SQL

check the Informix Guide to SQL : Syntax manual pages 1-560 through 1-570 for the math functions. (ABS,MOD,POW,ROOT,ROUND,SQRT,TRUNC,EXP,LOGN,LOG10,HEX). regards, bob baskett _______________________________________________________________________________ Subject: Math in Informix SQL From: lanny@terren.com@smtpsend at #EMAIL Date: 4/4/96 2:32 PM Apparently-To: RZBJ40@email.sps.mot.com 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. Any ideas ? V. Lanny Rosicky - lanny@terren.com