title: Select just first line of chars up to CR/LF from a text column
body: <p>Is it possible to select or substring just the first line of chars in a SQL Server text column, to then prepend as the first line of chars in another text field in another table?</p>