A table contains text comments for an order. During input, the application breaks the text at 60 char and inserts as multiple rows. Each row is given a sequential line number.
I need to output this data in a report, but doing so as-is looks very broken and choppy. I want to use a query to concatenate the rows into one and pass that into the report designer where it can be properly formatted
A simple Select looks like this:
where CompCode = ‘A1’
and Ord_num = 628649
Output looks like
2 CS Hold 5 Items are being ordered in less tha
3 n Full
4 Master Case Qty. Emailed customer to revise P
5 O. JO 4-23
Desired output is a single column, single row with all Line_Text concatenated. Note: there are CR/LF after row 1 and 3, the character needs to remain in the concatenated string
Can this be done in a standard query without creating a user defined function?