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

    "AND" function in Custom SQL


      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"



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

      Thanks a lot.