Running ASE 11.9. I have a text data type (column = longvalue) that is used to store multiple fields of data separated by LF. I need to be able select a specific field/string from within the longvalue column. To do that I assume I have to count the LF's and then select my string from that position. I'm not an SQL expert and don't know how to count the LF/Char(10). Any hints would be appreciated.

You will probable end with some messy combination of substring(charindex