SQL Queries||How to get last two specific letters of column using string functions?

Published: 25 March 2024
on channel: LearnSQLtoSSIS
44
2

SELECT * FROM [dbo].[person] WHERE SUBSTRING(name,LEN(name)-1,2)='on'

SELECT * FROM [dbo].[person] WHERE RIGHT(name,2)='on'


On this page of the site you can watch the video online SQL Queries||How to get last two specific letters of column using string functions? with a duration of hours minute second in good quality, which was uploaded by the user LearnSQLtoSSIS 25 March 2024, share the link with friends and acquaintances, this video has already been watched 44 times on youtube and it was liked by 2 viewers. Enjoy your viewing!