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,

       

      Thanks,

      Regards,

      Bikash