As always your help is much appreciated. This function is going into my db template.
I think I am missing how to apply it in this context in a remote view
Select cname, mline(memfld,1) as cline1, mline(memfld,2) as cline2, mline(memfld,3) as cline3
I would imagine that in each mline call I would call the function on the varchar(max) field, but since the function returns multiple records I would also need to specify which line of the array goes into the result set in that position.
What am I missing ?
(my first instinct is to add another param specifying the row and to modify the return value to single line but being t-sql impaired I realize there may be another way )
TIA
>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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.