Edit

Share via

SPACE (Azure Stream Analytics)

  • Article

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