sql: RIGHT and LEFT

sql query
select RIGHT(value,noofCharater);
select LEFT(value,noofCharater);


select RIGHT('pabitra',2)-- result ra
select LEFT('pabitra',2)--result pa

RIGHT: It extract right value from given no.
RIGHT: It extract left value from given no.