I am creating a view from two tables. tbl1 - Sales and tbl2 Shipments.
My selection is as follows:
SalesOrder, ShippedOrders , OrderDate, ShipDate, TrackingNumber, Expr1
I need to find if ShippedOrders column contains an order from SalesOrder column.
For Example: SalesOrder is equal to AB345
ShippedOrders is equal to AB345 AB344 AB367
If SalesOrder AB345 is found in ShippedOrders column I would make Expr1 equal to SalesOrder.
Any help greatly appreciated