LEFT, RIGHT and MID functions extract a substring from a string. We can specify how many characters to be extracted. This functions are categorized as a String/Text Function.
In this video we described how to use LEFT , RIGHT and MID functions in different situations.