Split_Part function in SQL Server? HOW?

Actually, Sql-Server doesn't have this function, but we may perform the similar work by using some other functions.

#sql, #sqlinterview , #sqlserver , #data , #datanalysis