SPACE

Purpose

SPACE creates a string consisting of n spaces.

Syntax

space::=

Usage Notes

  • Where n is an integer value greater than 0.
  • For additional information, see REPEAT.

Example

SELECT 'x'||SPACE(5)||'x' my_string;