Ways of extracting First CharacterS in Sql Server

Posted by vishalneeraj-24503 under Sql Server category on 12/29/2014 | Points: 40 | Views : 1190

1st way:-

select substring('Vishal', 1, 1) as First_Character

2nd way:-

select left('Vishal', 1) as First_Character

Output:-V

Alert Moderator

Bookmark It

Latest Code Snipptes