Home Forums SQL Server 2008 SQL Server 2008 - General Can I concatenate fields on the thame row? RE: Can I concatenate fields on the thame row?

  • June 29, 2015 at 12:50 pm

    #1808897

    jbalbo (6/29/2015)

    Actually I just tried

    case when (Question1 = N'No') then 'text here ' else '' end

    + case when (Question2 = N'No') then 'text here ' else '' end

    + case when (Question3 = N'No') then 'text here ' else '' end as result

    It works, but maybe something better ?

    If this works for you then use it. I don't think there's a much better way to do it.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]