declare @value as varchar(100) set @value = 'The string / unwanted' select stuff(@value,1, CHARINDEX('/',@value),'') select stuff(@value,CHARINDEX('/',@value), len(@value) ,'')
declare @value as varchar(100) set @value = 'The string / unwanted' select stuff(@value,1, CHARINDEX('/',@value),'') select stuff(@value,CHARINDEX('/',@value), len(@value) ,'')