I have a query based on several joins. One table I am joining in may have one row or multiple rows based on the size of the text in this field. So results may look like this
name ID segmentID text
where text exceeds 2000 characters, additional rows are added to accommodate the next segment of texts. So data set looks like this:
name ID segmentID text
JIM 1 400 some text less than 2000 characters
SAM 2 503 some text > 2000 characters
SAM 2 503 some text > 2000 characters
In cases where there are multiple entries due to this text size issue, I need to concatenate the text field into one result.
Is there any way to do this?
thanks.
kd