SQL Server/T-SQL/String Functions/RIGHT

Get string to the right

25>
26> IF EXISTS(SELECT name FROM sys.tables
27>     WHERE name = "T")
28>     DROP TABLE T
29> GO
1>
2> CREATE TABLE T (
3>     c1 int,
4>     c2 varchar(8000)
5> )
6> GO
1>
2> DECLARE @v1 varchar(max)
3>
4> SET @v1 = REPLICATE("A",7999) + "B"
5> INSERT T VALUES (1, @v1)
6> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T
7>
8> SET @v1 = @v1 + "B"
9> INSERT T VALUES (2, @v1)
10> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T
11> GO
(1 rows affected)
Right 2 of c2
-------------
AB
Msg 8152, Level 16, State 10, Server sqle\SQLEXPRESS, Line 9
String or binary data would be truncated.
The statement has been terminated.
(1 rows affected)
Right 2 of c2
-------------
AB
(1 rows affected)
1>
2> drop table t
3> GO

RIGHT: return a number of characters from the right-hand side of a string

1> -- RIGHT: return a number of characters from the right-hand side of a string.
2>
3> DECLARE @RIGHT_STRING char(100)
4> SET @RIGHT_STRING = "www.sqle.ru"
5>
6> SELECT RIGHT(@RIGHT_STRING,10)
7> GO
----------

(1 rows affected)
1>

RIGHT(@RIGHT_STRING,10)

1> -- This produces a result of ten spaces, because the last 10 characters are 
space filled.
2>
3> DECLARE @RIGHT_STRING varchar(100)
4> SET @RIGHT_STRING = "www.sqle.ru"
5>
6> SELECT RIGHT(@RIGHT_STRING,10)
7> GO
----------
sqle.ru
(1 rows affected)
1>

RIGHT(): starts at the right-most character and counts to the left, returning the specified number of characters

1>
2> -- RIGHT(): starts at the right-most character and counts to the left, returning the
3> -- specified number of characters.
4>
5>
6> DECLARE @FullName VarChar(25)
7> SET @FullName = "George Washington"
8> SELECT RIGHT(@FullName, 5)
9>
10> GO
-----
ngton
(1 rows affected)
1>