Menu

LEFT  and RIGHT  are used to retrieve parts of a content in a column starting from left and right respectively.

John has four characters. Starting from left for 2 characters, we should get ‘Jo.’ Starting from right for 2 characters, we should get ‘hn.’


In addition to text, LEFT  and RIGHT  can also retrieve numbers from integer variable.


However, the returned data type will be character.


Unless, we use CAST .