R

REVERSE in SQL Server

REVERSE function returns the string in to reverse order character by character or digit by digit including blacks / spaces.

C

CHARINDEX in SQL Server

CHARINDEX returns the starting position of the substring passed in the CHARINDEX function. Syntax: In above START_LOCATION is optional parameter

L

LEN in SQL server

LEN(‘ANY_STRING’) returns number of characters in the ANY_STRING leaving trailing blanks uncounted (means it doen’t count ending spaces/blanks ). SYNTAX:

R

RIGHT in SQL SERVER

RIGHT is used to extract the substring from a string strating from the RIGHT most character. SYNTAX : EXAMPLES :

L

LEFT in SQL SERVER

LEFT is used to extract the substring from a string, strating from the left most character. SYNTAX : EXAMPLES :