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

Thanks.