Home » RDBMS Server » Server Administration » Concatenation text issue
Concatenation text issue [message #374333] Wed, 06 June 2001 10:12
Toyn
Messages: 36
Registered: April 2001
Member
I have a text field in which each line of text is inserted into a new row. These rows of text are all of the same report, and all have the same accession number. For each new line of text a new row is created, with the text field being populated with the new text, and the accession fields being populated with the same accession number of the report.
(i.e. acc1 'hello' <next row> acc1 'how are you?'). I would like to concatenate these rows to read 'hello how are you?' into a single row and then export that row into another table. I haven't had much success with concatenation operators. Any help would be appreciated. Thanks.
Previous Topic: creating a condition using sql
Next Topic: Concatenation text issue
Goto Forum:
  


Current Time: Mon Dec 23 13:04:48 CST 2024