Spliting Data

Hello I am back again to give you all some more questions and answers.
OKok .... I was just doing some of my program just now in VB6.0 and just used the Split command.
And I am starting to wonder does SQL7.0 Query have a split command?
issit something to do with the Parse and or CAST?

Example data: 202;788889;289067;549879475;549869587;59879054;1;0 ;;;64363;

Example Result:
202
788889
289067
549879475
etc....

Ok see above data is split by ';' and in VB6 use the split command and put it into an array. It works like a charm.
How about SQL Query?

There is not one that I know of, but I do know that there are several stored prcedures on the net that people have written for most RDBMS'. Google "SQL split function" for a dozen of them!