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.