I am working on a project where i have encounter such problems:
with upto 8 dashes
I need to find the values behind each dashes into multiple columns in orders.
[e.g LA-1-2-33 will have columnA = 1,columnB = 2,columnC=33...etc.].
Since there are alot of situations,i dont know how to query it. [there is a way to do it by using declare & count but very tedious].
*im new to mssql. Please elaborate as much as possible if you have "advance" queries like create functions.
Thanks Very Much! =)