Just use the between keyword

select * from mytable
where myfield between '1/3/03' and '3/17/03'

Check the BOL for more info...



>Hi All:
> What is the equivalent of between() in sql?
>Thanks
>MA