I need your assistance with a query.
I have a simple query that shows me all records for a specific sales id, however, some changes have been made to the sales_id. The sales_id used to be something like this 4562, now it has change to something RTUBFGH-4562-10-896001455-AUST-7895663. The sales_id is the number between the first and second dash 4562. The first part of the sales_id is not always RTUBFGH, it changes according to requirements.
How can I modify the below query so it show me the records for sales_id 4562?
Select * from sales
Where sales_id = ‘4562’