1 Reply Latest reply on Dec 26, 2013 3:16 AM by Thasan Vallipuranathan

    "AND" function in Custom SQL

    jabrane.belghith

      Hello Every One;

       

      Is It possible to add a new field "CompleteName" with custom Sql that conatin 2 other field from the same TAble??  What I want to do :


      "STUDENT"."Firstname" AS "Firstname",

        "STUDENT"."LastName" AS "LastName",

      "STUDENT"."Firstname"  & ' . ' &  "STUDENT"."LastName" AS "CompleteName"

      FROM "SCOLARITE"."STUDENT" "STUDENT"

       

      I m looking to add the ' . ' between the first name and the last name , then rename the field .

      Thanks a lot.