1 Reply Latest reply on Mar 4, 2008 11:43 AM by Günter Schenk

    CONCAT two columns in the QuB

      How do you CONCAT two columns in the QuB? I want to combine the First_name column and Last_name Column into one column.

      Thanks,
      Cheryl
        • 1. Re: CONCAT two columns in the QuB
          Günter Schenk Level 4
          Hi Cathy,

          QuB doesn´t support concatenating columns, but it´s rather easy to add that functionality to the generated query afterwards, e.g.

          CONCAT(first_name, " ", last_name) AS fullname, column_two etc etc

          Once you have this declared, just use the alias column "fullname"

          Cheers,
          Günter Schenk
          Adobe Community Expert, Dreamweaver