RIGHT FUNCTION IN SQL SERVER 2005
The RIGHT function retrieves the portion of the string counting from the right. For example:
SELECT * FROM Employee
OUTPUT
_________________
1 Pawan 180000
2 Gaurav 80000
3 Saurabh 80000
4 Pawan 830000
5 Neelam 80000
SELECT RIGHT ( EMPNAME , 2) AS ‘RIGHT TWO CHARACTERS OF EMPNAME’ FROM Employee
OUTPUT
_________________
RIGHT TWO CHARACTERS OF EMPNAME
an
av
bh
an
am
SELECT RIGHT ( EMPNAME , NULL ) AS ‘RIGHT TWO CHARACTERS OF EMPNAME’ FROM Employee
OUTPUT — It will give you NULL 5 times
______________________________________
RIGHT TWO CHARACTERS OF EMPNAME
NULL
NULL
NULL
NULL
NULL
SELECT RIGHT ( NULL , 2 ) AS ‘RIGHT TWO CHARACTERS OF EMPNAME’ FROM Employee
OUTPUT — It will give you NULL 5 times
______________________________________
RIGHT TWO CHARACTERS OF EMPNAME
NULL
NULL
NULL
NULL
NULL
SELECT RIGHT ( NULL , 10 ) AS ‘RIGHT TWO CHARACTERS OF EMPNAME’
OUTPUT
______________________________________
NULL
Pawan Kumar
Pawankkmr@hotmail.com