docs.intersystems.com
Home  /  Application Development: Core Topics  /  InterSystems SQL Reference  /  SQL Functions  /  SQUARE


InterSystems SQL Reference
SQUARE
[Back]  [Next] 
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