SPACE

✅ Azure Stream Analytics ✅ Fabric Eventstream

Returns a string of repeated spaces.

Syntax

SPACE ( integer_expression )

Arguments

integer_expression

Is a positive bigint expression that indicates the number of spaces. If integer_expression is negative, a null string is returned.

Return Types

nvarchar(max)

Examples

SELECT
    RTRIM('LastName  ') + ',' + SPACE(1) +  LTRIM('    FirstName') as FullName
FROM Input

FullName
LastName, FirstName

See Also

• RTRIM
• LTRIM