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 ,CHhttp://javarevisited.blogspot.com/2012/12/charindex-padindex-sybase-sqlserver-eample-split...