It appears you have a curly-quote instead of apostrophe in one of your expressions:
WHEN 'more than 16 months ‘ THEN 17
Try this instead:
WHEN 'more than 16 months ' THEN 17
Thanks, that was it. I sure did not see that difference at all. And on my keyboard there is only one option, so I'll have to retrace my steps on how that was corrupted somewhere in my process.
Thanks so much.
The curly-quotes often sneak in as "smart quotes" from Microsoft applications, including Office, PowerPoint and Outlook. So copy/paste from a colleague's email is all it takes, sometimes.
Hey Leslie: Make sure to mark your question "answered" in some way -- you can mark one of Robert's responses as the "correct answer" so others know you have found a solution to your problem. Cheers!