[SQL] Multi-line text fields

2008-09-22 Thread Mike Toews
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

Re: [SQL] order function in aggregate

2008-08-20 Thread Mike Toews
Richard Huxton wrote: Michael Toews wrote: You could accumulate the values in an array and then sort that with the final-func that create aggregate supports. Thanks for the help. Here was my final functions to aggregate things into a comma serpented text element (if anyone is interested):