doss.tychicus (11/10/2008)

---

I'm trying to get the data from the table

between two dates and for the List of Doctors

select * from tbl_test

where convert(char(10),createdate,121) between '2008-01-01'

and '2008-12-31' and id_doctor in (1,2,3,4,5)

I want to use two variables for the dates and one array for id_doctors

Pl Help :w00t: