Left and Right functions in SQL?

Answer 1

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

Answer 2

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"

"Woods"