Guys, Does anyone know the T-Sql equivalents of the VFP ALINES() and MEMLINES() Functions? I am trying to write a SPROC to Parse a text field in SQL Server 2000 that has a format of :

=1
aaaa
bbbb
cccc
dddd
eeee
ffff
gggg

=2
aaaa
bbbb
cccc

etc., you get the picture. I want to break it down one character row at a time within the text field, set '=1' to a memvar, execute a statement with it as a parameter, set 'aaaa' to a memvar and execute a statement with it as a parameter. This would take about .005 seconds to do with fox but I have to do it on the SQL Server. We are moving everything to C# soon so my solution has to be scalable. ????

Woodie