docs.intersystems.com
Home / InterSystems SQL Reference / SQL Functions / SQUARE


InterSystems SQL Reference
SQUARE
Previous section           Next section
InterSystems: The power behind what matters   
Search:  


A scalar numeric function that returns the square of a number.
Synopsis
SQUARE(numeric-expression)
Arguments
numeric-expression An expression that resolves to a numeric value.
SQUARE returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, SQUARE returns DOUBLE; otherwise, it returns NUMERIC.
Description
SQUARE returns the square of numeric-expression. SQUARE returns NULL if passed a NULL value.
The precision and scale returned by SQUARE are the same as those returned by the SQL multiplication operator.
Examples
The following Embedded SQL example returns the squares of the integers 0 through 10:
   SET a=0
   WHILE a<11 {
   &sql(SELECT SQUARE(:a) INTO :b)
   IF SQLCODE'=0 {
     WRITE !,"Error code ",SQLCODE
     QUIT }
   ELSE {
     WRITE !,"The square of ",a," = ",b
     SET a=a+1 }
   }
See Also


Previous section           Next section
View this book as PDF
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-02-22 00:52:40