| Remove last or first character from string in SQL Query?
Below is the code to remove first or last chaacter from string in SQL Query
(1)SQL remove first character
(i)By using Right keyword
Declare @EmpName as varchar(20)='Crackyourinterview.com'
Select right(@EmpName,len(@EmpName)-1) as FirstCharacterRemove
Output:-
rackyourinterview.com
(ii)By using substring keyword
Declare @EmpName as varchar(20)='Crackyourinterview.com'
Select substring(@EmpName,2,len(@EmpName)-1) as FirstCharacterRemove
Output:-
rackyourinterview.com
(2)SQL remove last Character
(i)by using Left keyword
Declare @EmpName as varchar(20)='Crackyourinterview.com'
Select left(@EmpName,len(@EmpName)-1) as LastCharacterRemove
Output:-
Crackyourinterview.co
(ii)By using substring keyword
Declare @EmpName as varchar(20)='Crackyourinterview.com'
Select substring(@EmpName,1,len(@EmpName)-1) as FirstCharacterRemove
Output:-
Crackyourinterview.co | | |