Resp.: [SQL] Multi-line text fields

2008/9/23, Craig Ringer <[EMAIL PROTECTED]>: > Mike Toews wrote: >> Hi all, >> >> I have some records that have some multiple lines within a single text >> field. (On top of that, I think I have mixed DOS/UNIX line endings too). >> I'm looking for two functions which can operate on a single field:

Re: [SQL] Multi-line text fields

Mike Toews wrote: Hi all, I have some records that have some multiple lines within a single text field. (On top of that, I think I have mixed DOS/UNIX line endings too). I'm looking for two functions which can operate on a single field: 1. number of lines A few different ways, none of wh

[SQL] Multi-line text fields

Hi all, I have some records that have some multiple lines within a single text field. (On top of that, I think I have mixed DOS/UNIX line endings too). I'm looking for two functions which can operate on a single field: 1. number of lines 2. a way to select the first line or to trim to the