SPACE

 

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


100% pure Java DBMS
Mirror Site