SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-141
SPACE Function
SPACE Function
The SPACE function returns a character string consisting of a specified number of
spaces.
SPACE is an SQL/MX extension.
length
specifies the number of characters to be returned. The number count must be a
value greater than or equal to zero of exact numeric data type and with a scale of
zero. length cannot exceed 4096.
char-set-name
can be ISO88591, KANJI, KSC5601, or UCS2. The default is ISO88591.
The returned character string will be of data type VARCHAR associated with the
character set specified by char-set-name.
Examples of SPACE
•
Return 3 spaces:
SPACE (3)
SQRT Function
The SQRT function returns the square root of a numeric value expression.
SQRT is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the SQRT function. The value of the argument must not be a negative number.
See Numeric Value Expressions on page 6-48.
Examples of SQRT
•
This function returns the value 5.19615242270663312E+000, or approximately
5.196:
SQRT (27)
SPACE (length [,char-set-name])
SQRT (numeric-expression)