Skip to content

Settings and activity

3 results found

  1. 52 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Vern Rabe supported this idea  · 
  2. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Vern Rabe commented  · 

    Well, the comment format is not at all what I submitted. I'll try again:

    SELECT CASE
    WHEN COL = 1
    THEN 'COL 1'
    ELSE ''
    END + CASE
    WHEN COL = 2
    THEN 'COL 2'
    ELSE ''
    END + CASE
    WHEN COL = 3
    THEN 'COL 3'
    ELSE ''
    END AS ConcatStr
    FROM #Test;

    What I'd like to get is:

    SELECT CASE
    WHEN COL = 1
    THEN 'COL 1'
    ELSE ''
    END
    + CASE
    WHEN COL = 2
    THEN 'COL 2'
    ELSE ''
    END
    + CASE
    WHEN COL = 3
    THEN 'COL 3'
    ELSE ''
    END AS ConcatStr
    FROM #Test

    Vern Rabe shared this idea  · 
  3. 10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Vern Rabe supported this idea  ·