I have a query for an exception report.
where term_date is null
and to_char(eff_date,'MM/DD/YYYY') >= to_char(sysdate,'MM/DD/YYYY')
and telex_no = '137-000-0000'
WAD-PA0352,ST ANTHONY - MICHIGAN CITY FRANCISCAN
WAD-RG0242,ST ANTHONY - MICHIGAN CITY FRANCISCAN
But I need help in also adding if the substr(telex_no,1,3) changes. There is a possibility that the first three digits may change as they represent the price code and direct bill or consignee. Right now I have the query for
telex_no = '137-000-0000' to give an example. But I need to add if any of the first three characters change.