Left and Right are inbulid functions in SQL.
While Right gives character from Right side of a string, Left give string from Left side.
Select Left('your name',4) Ans- your
Select Right('your name',4) And- name
These functions return the left and right parts of a string. The syntax for the LEFT function is:
LEFT(CUSTNAME,6)
For the two customers, the leftmost 6 characters are:
"Mr. Ti"
"Mrs. E"
The space between the period and the first name counts as a character.
The RIGHT function has exactly the same syntax:
RIGHT(CUSTNAME,5)
and returns the values
"Woods"