SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

8-170

SPACE Function

The SPACE function returns a character string consisting of a specified number of

spaces each of which is 0x20 (for the ISO88591 character set), 0x0020 (for the UCS2

character set), or 0x2020 (for the KANJI and KSC5601 character sets).

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 32768 for the ISO8859-1 character set or 16384 for

the UCS2, KANJI, and KSC5601 character sets.

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-52.

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)