Some of my friends has a lot of confusions about the functions SPACE() and it's implementations.
The SPACE function takes Integer as parameters and Returns a specified number of spaces as string.
The number of space it returns is what number you provide in the parameters.
The syntax is
SPACE(expression int)RETURN varchar
SELECT fname +','+SPACE(2)+lname 'Student Name'
The Spce came in between , and Last name.
Posted By: MR. JOYDEEP DAS