Taking the Rightmost Part of a String : Right « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. Right
3>
4> SELECT RIGHT('www.java2s.com java2s', 10)
5> GO

--------------------
com java2s

(1 rows affected)
1>








12.16.Right
12.16.1.RIGHT return a number of characters from the right-hand side of a string.
12.16.2.Prefixing a Numeric Value with Zeros
12.16.3.Taking the Rightmost Part of a String
12.16.4.Padding a number for business purposes with right