RIGHT return a number of characters from the right-hand side of a string. : Right « String Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. String Functions
3. Right

4> DECLARE @RIGHT_STRING char(100)
5> SET @RIGHT_STRING = "www.java2s.com, www.java2s.com java2s"
6> SELECT RIGHT(@RIGHT_STRING,10)
7> GO

--------------------


(1 rows affected)
1>
2> DECLARE @RIGHT_STRING varchar(100)
3> SET @RIGHT_STRING = "java2s"
4> SELECT RIGHT(@RIGHT_STRING,10)
5> GO

--------------------
java2s

(1 rows affected)