Stored Procedure to Split String in SQL

Tutorials Shared by the Internet Community

Advertisements


Synopsis

Unfortunately there is no split() function in Sybase or SQL Server to split string based upon any delimiter. You need to use methods like PATINDEX ,CH

Statistics

  • Total Hits - 27245

  • Total Votes - 156 votes

  • Vote Up - 56 votes

  • Vote Down - 100 votes

  • Domain - javarevisited.blogspot.com

  • Category - MsSQL/Stored Procedures

  • Submitted By - Javin Paul

  • Submitted on - 2013-11-21 08:28:13

Description

Unfortunately there is no split() function in Sybase or SQL Server to split string based upon any delimiter. You need to use methods like PATINDEX ,CHARINDEX ,LEFT etc to split String. This article shows example of stored procedure to splitting comma separate string. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements