Re: Calculating square root in ISQL

Bonnie Weller (weller@zorro.cecer.army.mil) wrote: : Hello : I have SE 5.01 ISQL 4.11. I do NOT have 4GL (which I understand can : do square roots.) : I need to compute the following into an sql statement. : _____________________ : \\ | 2 2 : \\| (x1-x2) + (y1-y2) < r1+r2 : I am not sure how to do the square root part of the equation as isql does : not have this capability. I find that surprising. Square root has been in the engine since <=5.00. select sqrt(whatever) ... works on my OnLine 5.00 engine, I would expect it to work with SE also. If you believe isql is the problem, why not use dbaccess? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.