2 Replies Latest reply: Jun 22, 2011 6:52 PM by Angus Monro RSS

    Concatenate Issue

      Hi Everyone,

      I am trying to create a unique key based on Item No and Part Number. They both are fields in my data model.

      This is what I have written but it seems its picking only the first part.


      For example


      Item_Number is 123456

      Part_Number is 731AS25Z

      and i require this 123456_ 731AS25Z


      I have written this line,

      Item_Number & '_' & Part_Number as Item_Part



      But it doesn't work.


      Please suggest,