в 13:46, 26 мая 2010

2010-05-26T13:46:16Z

Admin: 1 версия

2010-05-26T10:22:22Z

1 версия

Новая страница

== 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>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL Server/T-SQL Tutorial/String Functions/LTRIM - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия