SELECT ASCII('F')
RETURNS ASCII CODE OF CHARACTER
SELECT CHAR(70)
RETURNS THE CHARACTER EQUIVALENT OF THE ASCII CODE.
SELECT CHARINDEX('K','ARUN KUMAR')
RETURNS THE STRING POSSITION OF THE SPECIFIED PATTER.
SELECT LOWER("ENGLISH")
CONVERT TO LOWERCASE
SELECT UPPER("ENGLISH")
CONVERT TO UPPERCASE
SELECT LTRIM(" ENGLISH")
RETURNS DATA WITHOUT LEADING BLANKS
SELECT RTRIM("ENGLISH ")
RETURNS DATA WITHOUT TRAILING BLANKS
SELECT REVERSE("ENGLISH")
RETURNS THE REVERSE OF GIVEN STRING
SELECT REPLICATE("ENGLISH",3)
REPEATS THE CHARACTER EXPRESSION A SPECIFIED NUMBER OF TIMES.
SELECT LEFT("ENGLISH",3)
RETURNS PART OF A CHARACTER STRING STARTING INTEGER_EXPR CHARACTER FROM THE LEFT.
SELECT RIGHT("ENGLISH",3)
RETURNS PART OF A CHARACTER STRING STARTING INTEGER_EXPR CHARACTER FROM THE RIGHT.
SELECT REPLACE("ENGLISH","G","K")
REPLACES ALL OCCURRENCES OF THE SECOND GIVEN STRING EXPRESSION IN THE FIRST STRING EXPRESSION WITH A THIRD EXPRESSION.
SELECT LEN("ENGLISH")
RETURNS THE LENGTH OF CHARACTER EXPRESSION.
SELECT SUBSTRING("ENGLISH",4,3)
RETURNS PART OF A CHARACTER EXPRESSION.
SELECT SPACE(20)
RETURNS A STRING OF REPEATED SPACE.
