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



      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'