mos <[EMAIL PROTECTED]> wrote on 12/18/2005 06:36:16 PM: > How do I square a number in MySQL 4.1? I thought it would be something > simple like: > > select 3**2 > > but that produces a syntax error. I can use Pow(3,2) but that produces a
> float. Is there a Square function? TIA > > Mike > If you took 7th grade math, you should know that squaring a number is shorthand for multiplying it by itself. I commend the MySQL designers for leaving out a function to do such a simple thing. IMHO if you use N*N, you will get as accurate results as if there were a SQR(N) function you could call. This is just too simple to need a function to evaluate. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
