Re: Reading shell script within 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. You can avoid the squar root problem entirly by comparing the square of each side i.e.: 2 2 2 test (x1-x2) + (y1-y2) < (r1+r2) -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Jason Restad | jrestad@ftc.scs.ag.gov USDA, Soil Conservation Service | jasr@ftc.scs.ag.gov 2625 Redwing Rd., Suite 110 | Ft. Collins, Colorado 80526 |