4 Replies Latest reply: Aug 2, 2017 11:09 PM by Akpofure Enughwure RSS

    Select name character

    Akpofure Enughwure

      Hello everyone,

       

      I have a table of staff name I pulled from sql,

      First NameMiddle NameLast NameCode
      JohnN/ALee001
      KittyBrownFrankie002
      TracyMoleChuck003
      GrantN/ASam004

       

       

      This is the sample of the data.  N/A is there because the staff doesn't have a middlename.

       

      I need to concatenate the First Name, Middle Name and Last Name  to give Full Name

       

      I'm using this expression:

      Last_Name&' '&"Middle_Name"& ' '&First_Name as [Full Name]

      but if I use the above expression for the staff with code 001.. full name will become John N/A Lee and this is not valid

       

      How do I edit it so I will skip Middle Name when Middle Name  = 'N/A'