3> DECLARE @STRING_WITH_SPACES VARCHAR(30)
4> DECLARE @STRING_WITHOUT_SPACES VARCHAR(30)
5> SET @STRING_WITH_SPACES = "www.rntsoft.com rntsoft"
6>
7> SET @STRING_WITHOUT_SPACES = RTRIM(@STRING_WITH_SPACES)
8>
9> SELECT @STRING_WITH_SPACES + "!"
10> SELECT @STRING_WITHOUT_SPACES + "!"
11> GO
-------------------------------
www.rntsoft.com rntsoft!
(1 rows affected)
-------------------------------
www.rntsoft.com rntsoft!
(1 rows affected)