query returning empty row

SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE cCurstatus!='completed' AND cMmrcashworker = '2' AND (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND updateDate between '2010-01-01' and '2010-01-28' order by id desc I have one patient entry,and his

Re: query returning empty row

In the last episode (Jan 17), bharani kumar said: SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE cCurstatus!='completed' AND cMmrcashworker = '2' AND (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND updateDate between '2010-01-01' and '2010-01-28'

Re: query returning empty row

thanks for reply, problem fixed, On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Jan 17), bharani kumar said: SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE cCurstatus!='completed' AND cMmrcashworker = '2' AND