SPACE

Purpose

This function creates a string consisting of n number of spaces.

Syntax

space::=

Usage Notes

  • n must be an integer value greater than 0.
  • For additional information, see REPEAT.

Example

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