With the little data you have posted ... use Books on Line and check the use of the BETWEEN statement
From Books on Line:
test_expression BETWEEN begin_expression AND end_expression
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]