SQL Function: SPACE()

Definition:

Return spaces with provided number


Command Syntax:

SPACE(number)

Command Example:

Input:
SELECT '123'+SPACE(4)+'abc' AS RESULT;

Output:
RESULT
123    abc


‘Cannot imagine how the question using this function will be in exam.’By secondary 6 student

Comments