• This is mostly due to us being forced to speculate on your table. Dwain assume you have multiple rows but my guess is your table holds the entire discussion more in a format like this?

    ;WITH Transcript (message) AS (

    SELECT '20:32:12 [Rachel] Thank you for contacting Our Company. How may I assist you?'

    + char(10) + char(13) + '20:32:31 [Marina Galofaro] What is the mailing address to mail a check?'

    + char(10) + char(13) + '20:32:49 [Rachel] I''m happy to provide you with the mailing address.'

    + char(10) + char(13) + '20:33:22 [Marina Galofaro] O kay, Thank you.'

    + char(10) + char(13) + '20:33:28 [Rachel] One moment please while I provide a link with directions to mail your payment.'

    + char(10) + char(13) + '20:34:05 [Rachel] Please click <a href="http://company.custhelp.com/app/answers/detail/a_id/1050/kw/payment" target="_blank">here</a> to view how to mail a payment.'

    + char(10) + char(13) + '20:35:07 [Rachel] Is there anything else I can help with, Marina? '

    + char(10) + char(13) + '20:35:56 [Marina Galofaro] No, Thank you!'

    + char(10) + char(13) + '20:36:00 [Marina Galofaro] Session Disconnected')

    select * from transcript

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/