SQL Server/T-SQL Tutorial/String Functions/LTRIM

Материал из SQL эксперт
Перейти к: навигация, поиск

LTRIM Removes leading spaces from a string.

   <source lang="sql">

4> 5> DECLARE @STRING_WITH_SPACES VARCHAR(30) 6> DECLARE @STRING_WITHOUT_SPACES VARCHAR(30) 7> SET @STRING_WITH_SPACES = " www.sqle.ru" 8> 9> SET @STRING_WITHOUT_SPACES = LTRIM(@STRING_WITH_SPACES) 10> 11> SELECT @STRING_WITH_SPACES 12> SELECT @STRING_WITHOUT_SPACES 13> GO


www.sqle.ru

(1 rows affected)


www.sqle.ru (1 rows affected) 1></source>


Removing Leading Blanks

   <source lang="sql">

6> 7> SELECT LTRIM(" www.sqle.ru sqle.") 8> GO


www.sqle.ru sqle. (1 rows affected)</source>


select LTRIM(" SQL Server ")

   <source lang="sql">

3> 4> select LTRIM(" SQL Server ") 5> GO


SQL Server (1 rows affected) 1></source>


The LTRIM() and RTRIM() Functions

   <source lang="sql">

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)</source>