You can use the rich in-built function set of SQL Server 2005 to perform a variety of tasks. Let us explore how to repeat a group of characters 'n' number of times and also insert space in between two strings.
Repeat a group of characters 'n' number of times
Use the REPLICATE() function to repeat a character expression for a specified number of times
SELECT REPLICATE('-',15) as Underline
displays: the character '-' 15 times ---------------
Insert space in between two strings
SPACE() function returns a string of repeated spaces depending on the number specified
SELECT 'Far' + SPACE(10) + 'Away'
displays: 'Far Away'