• declare @date datetime

    Set @date = '2011-07-31 00:00:00.000'

    IF (@date BETWEEN '2011-07-01' and '2011-07-31')

    PRINT 'Yes'

    ELSE

    PRINT 'No'

    does return Yes