Categories
SQL

SELECT RIGHT

RIGHT
Returns the part of a character string starting a specified number of integer_expression characters from the right.

Example

CREATE TABLE #CustomerNames
(
	CustomerId int,
	CustomerName varchar(25)
)	

INSERT INTO #CustomerNames
SELECT 1, 'Bob Johnson'
UNION ALL
SELECT 2, 'Al Riley'
UNION ALL
SELECT 3, 'Mike Henry'

SELECT RIGHT(CustomerName, 5) FROM #CustomerNames

Results
hnson
Riley
Henry

Related posts:

  1. IsNumeric function The function returns 1 for numeric values, and 0 for...
  2. SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL INSERT INTO MyTable (FirstCol, SecondCol) SELECT 'First', 1 UNION ALL...
  3. How To Convert Confusing Ascii Code To A Character CHAR can be used to insert control characters into character...
  4. How to access the EmptyDataTemplate controls from OnRowCommand in GridView For example – inserting value in the empty gridview: protected...