The function SPACE create a string of count blank characters.
SQL Syntax:
|
|
SPACE( count ) |
Parameters:
|
|
count
Any numeric expression.
|
Escape Syntax:
|
|
{fn SPACE( count ) } |
Return Type:
|
|
VARCHAR |
Examples:
SELECT ';' + SPACE( 2 ) + ';', 'a' + {fn SPACE(3)} + 'a'
Return Values: ; ;, a a
see also:
SQL String Functions
|