Hello,
I have 2 tables that I need to join by sales order number. This is the only common field. Unfortunately, one of the tables has the sales order number formatted like this... SO#1234 and on of the tables has the sales order number formatted like this.... 1234.
Is there any way to create a query that returns the sales order numbers of the first table without the "SO#" so that it matches table two? Or is there another way to link the fields that I'm not thinking about?
Thank you in advance for your help!