SQL Tutorials - 11.Separate characters in SQL like First and Last Name

In this tutorial we will learn how to split one column into two columns like first name and last name or state and city,

Keep this script in your records

SUBSTRING([Your Column name ],1,CHARINDEX('-',[ Your Column name])-1) As [Your Column name _ 1],

SUBSTRING([Your Column name],CHARINDEX('-',[ Your Column name])+1, LEN([Your Column name]))As [Your Column name _ 2]


Last but not the least, SUBSCRIBE to my YouTube channel to stay updated about the regularly uploaded new videos.