- What is SQL NCHAR Function?
NCHAR function returns the Unicode character based on the number_code in the Unicode standard.
Syntax: NCHAR(Number code)
The above query returns the Z character which code is 90 in ASCII.
- What is SQL PATINDEX Function?
The PATINDEX functions …
- What is SQL Left() Function?
LEFT function allows you to extract a substring from a string, starting from the left-most character.
In simple word left function will be return the string started from left side an Syntax or a string,
Syntax: LEFT (String, Number of characters)