I need your assistance.
I need to do a query to show me the sales for a particular customer but the customer id is like 123456-ERT-000-UUU. The customer number is 123456, the customer id is anything before the – dash.
How can I modify the below query so I can search for sales (customer number before the – dash)
Select * from
Where customer_id ????