SELECT *FROM KCA3WHERE AAE040 >= TO_DATE('"&rq1&"','yyyy/mm/dd') AND AAE040 <=TO_DATE('"&rq2&" 23:59:59','yyyy/mm/dd hh24:mi:ss') AND LTrim(Rtrim(AKA120))= UPPER('"&bzdm&"') AND Upper(AKC195) <> 'Z' ;