SQL Queries||How to get last two specific letters of column using string functions?
SELECT * FROM [dbo].[person] WHERE SUBSTRING(name,LEN(name)-1,2)='on'
SELECT * FROM [dbo].[person] WHERE RIGHT(name,2)='on'
SELECT * FROM [dbo].[person] WHERE SUBSTRING(name,LEN(name)-1,2)='on'
SELECT * FROM [dbo].[person] WHERE RIGHT(name,2)='on'
