I have a field that I am extracting from a table. In my first view I am extracting Customer Code from Comment field. I have the following code to do that; LEFT (STUFF(Comment, 1, CHARINDEX('Cus:', Comment + 'Cus:') + 3, ''), 7)
All works fine however in my next view when I am trying to link my newly created field Customer with Customer Master table to display the customer name, my customer name shows as Null.
Customer Code in Master Customer Table is a char(7) and a primary key.