SQL SPACE

by

SQL SPACE() function is used to return space characters, the number of the characters is indicated by the interger parameter. It is supported by MySQL and MS SQL Server, but not Oracle.

SQL SPACE Function Syntax

SPACE(int)

int: the number of the spaces.

SQL SPACE Function Example

SELECT SPACE(9)
-- Will return 9 space characters.

SELECT 'Hello' + SPACE(3) + 'World!'
-- Will return 'Hello   World!'
-- 'Hello', then 3 spaces, then 'World!'

SELECT 'Hello' + SPACE(0) + 'World!'
-- Will return 'HelloWorld!'
-- 'Hello', no space, then 'World!'

Leave a Comment