Notepad on-line
declare @name varchar(10) = 'SMITH,JON' SELECT SUBSTRING(@name, CHARINDEX(',', @name)+1, LEN(@name)) AS Name
Name----------JON
Post a Comment
No comments:
Post a Comment