Get last n character from string in SQL Server

By

Dear Code How to get last n character from string in SQL Server? For example how we get last 4 or 3 character from string.
Dear Topic Some one asked me couple of day before. I know its solve by substring and len function of SQL Server.But i write down a query more than one way . I assume that all of you aware about the inbuilt function of SQL Server .

Code Sample [SQL SERVER Query]

DECLARE @inputString varchar(100)
DECLARE @inputNumber int
SET @inputString='I am code bytopic'
SET @inputNumber=5

--first approch
SELECT RIGHT(@inputString,@inputNumber)

--second approch
SELECT REVERSE(SUBSTRING(REVERSE(@inputString),1,@inputNumber))

--third approch

SELECT SUBSTRING(@inputString,LEN(@inputString)-@inputNumber+1,LEN(@inputString))

Output
Output looks like below.


get last m char in sql server


Explanation
I solve this with three approach , Use reverse method of SQL Server which reverse the number .I use len function of SQL Server which return the length of given string in SQL Server.For example
SELECT LEN('ROHIT') then it will return 5.

read more..

2 comments: