Query to show records where text before '-' dash
Hi All,
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
Sales
Where customer_id ????
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
Sales
Where customer_id ????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER