UPDATE DELI_REVEICE_DELIVERY_MASTER SET AUTH_STATUS = 'V' WHERE AUTH_STATUS IN ('B','C','D','V') AND CONVERT(DATE,TO_DATE, 103) <= CONVERT(DATE,'04-07-2025', 103)

SELECT * FROM  DELI_REVEICE_DELIVERY_MASTER WHERE AUTH_STATUS IN ('B','C','D','V') AND CONVERT(DATE,TO_DATE, 103) <= CONVERT(DATE,'04-07-2025', 103)