SPACE (Azure Stream Analytics)
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for