Spaces
-
how to add spaces to a string? -
U can add spaces to string by enclosing the spaces in the two single quotes. For eg
declare @str1 varchar(10)
set @str1 = 'abcdef'
select @str1 +' '+ 'ghi'
the spaces in the qutoes will be added to the string.
-
Adding to the answer above, I am taking a wild guess that you are looking for a way to pad a string with spaces to make it a fixed length. If so, here is an example of that:
DECLARE @string VARCHAR(10)SET @string = 'abc'
PRINT @string + REPLICATE(' ', 10 - LEN(@string))
-
Following on from Chris, don't forget SPACE() to add a fixed number of spaces in a string
-
example of combining chris's solution with shawn's alternative would be:
DECLARE @string VARCHAR(10)
SET @string = 'abc'
PRINT SPACE(10 - LEN(@string)) + @string
**ASCII stupid question, get a stupid ANSI !!!** -
All good altrnatives but the easy way is to not use varchar. If you use Char(10) you know your string will always be 10 characters long.
Mike
-
Hard to answer that whern he doesn't tell where he wants the spaces.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply