Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

The LTRIM() and RTRIM() Functions

4> DECLARE @Value1 Char(10), @Value2 Char(10) SET @Value1 = 'One' 5> SET @Value2 = 'Two' 6> SELECT @Value1 + @Value2 7> SELECT CONVERT(VarChar(5), LEN(@Value1 + @Value2)) + ' characters long.' 8> SELECT RTRIM(@Value1) + RTRIM(@Value2) 9> SELECT CONVERT(VarChar(5), LEN(RTRIM(@Value1) + RTRIM(@Value2))) 10>  ' characters long trimmed.' 11> GO -------------------- One       Two (1 rows affected) ---------------------- 13 characters long. (1 rows affected) -------------------- OneTwo (1 rows affected)  characters long trimmed. ------------------------- 6 (1 rows affected)