I have to run several queries on SalesOrder and SalesOrderDetail in both current and history tables on a list of job status codes.
Processing the queries takes way too much time.
The status codes I am interested in start with a letter and end in two digits.
AND OldStatus in ('D01', 'D02',... 'D15'. ,'L01', 'L02', ... 'L15')
Is there a way to create a query that doesn't need a complete list of status codes?
Does LIKE have parameters that could help me out here?
{AND OldStatus LIKE 'D%##' OR OldSatus LIKE 'L%##' } ???