Can someone please explain working of RIGHT and LEFT functions working in SQL Server?

Answer 1

In SQL Server Right or Left is used to select a particular portion of a string, either from right side of it or from Left side. See an example below-

SELECT LEFT('HELLO WORLD', 3) Result- HEL

SELECT RIGHT('HELLO WORLD', 3) Result- RLD

Instead of these 2 we can use substring() also, it has few additional feature as well.