Check
http://www.berezniker.com/display/SQL/Alines+UDF+-+String+Split>In a memo field I would use mline to retrieve rows in a sql select.
>
>Now I need to obtain the first 3 rows of a varchar(max) where there are char(13)s breaking the lines. ( going into a remote view )
>
>
>I can figure the first left() statement using charindex(char(13),mfield,1) but I'm struggling with the substring() syntax for lines 2 -> n
>
>If I am converting an app where I'm doing a lot of this should I have a UDF that would extract row(n) from a varchar(max) ?
>
>Guidance appreciated, as always.
--sb--