SQL SERVER – SPACE Function Example | Journey to SQL Authority with Pinal Dave

A month ago, I wrote about SQL SERVER - TRIM() Function - UDF TRIM() . I was asked in comment if SQL Server has space function? Yes. SELECT SPACE(100) will generate 100 space characters. The use of SPACE() function is demonstrated in BOL very fine. Example from BOL: USE AdventureWorks; GO SELECT RTRIM(LastName) + ','… Continue Reading...

Source: SQL SERVER – SPACE Function Example | Journey to SQL Authority with Pinal Dave