Actually the case is the whole expression. I'm not writing a script, its an expression to create a custom field in a report designer application.

Thanks for your...

I got it again! Incorrect Syntax near '7'...........what does that mean? There's no 7 in the expression

Much simplier.........ok, thanks I will give a try

I want to pull all the records with an end dates on or before 01/31/11 and between 02/01/11 and 03/31/11.

Thanks for your response.

Just tried your fix. Got the following error msg:

"Conversion failed when converting the varchar value '01/31/2011' to data type int."