This question may sound strange but I have personally observed this being asked in one of the interview.
Question: How Does SPACE Function Works in SQL Server?
Answer: SPACE function accepts one numeric parameter and generates as many as space as a value of the parameter.
Observe the output of the following query:
SELECT RTRIM(LastName) + ',' + SPACE(5) + ',' + LTRIM(FirstName)
ORDER BY LastName, FirstName;
You will notice there is gap of five space between two commas.
Reference: Pinal Dave (https://blog.sqlauthority.com)