Space
Summary
Use the Space function to create a string composed of n spaces. The function is useful when concatenating columns together.
Syntax
Space(<integer>) |
The integer input parameter determines the number of spaces to put in the return string.
Return Type
String
Details
Space offers an alternative to using hardcoded spaces between ticks, enhancing code readability.
Consider the following hardcoded example to the one listed in the next section.
select first_name || ' ' || last_name as Space_example from xactly.xc_participant;
Examples
select first_name || Space(1) || last_name as Space_example from xactly.xc_participant;
