Woodie,
See
http://www.winnetmag.com/SQLServer/Article/ArticleID/21071/21071.html>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
If it's not broken, fix it until it is.
My Blog