Breaking News: Grepper is joining You.com. Read the official announcement!

space in sql

Abdullrhman elhelw answered on February 22, 2023 Popularity 6/10 Helpfulness 1/10

answer space in sql

space in sql

Comment

/*
SPACE() :
This function in SQL Server helps to return a string that has a specified number of spaces.
*/

SELECT SPACE(5) 
AS Result;

 /* Result 
    '  '
 */
 
SELECT 'Hello' + SPACE(4) + 'World' 
AS Welocme;

/*
Welocme
Hello     World
*/

-- if you enter invalid value the output will be null 
SELECT 'Hello' + SPACE(-1) + 'World' 
AS Welocme;
/*
Welocme
NULL
*/

Popularity 6/10 Helpfulness 1/10 Language sql

Source: www.geeksforgeeks.org

Tags: space sql sql-delete

Link to this answer
Share Copy Link