sqlserver中有类似于split方法吗,该怎么解决

declare @field nvarchar(15)set @field = 'K602-013-00'select parsename(replace(@field,'-','.'),1)union allselect parsename(replace(@field,'-','.'),2)union allselect parsename(replace(@field,'-','.'),3)--00--013--K602
------解决方案--------------------
低于4个'-'用parsename函数  


否则用2楼