By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,607 Members | 1,817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,607 IT Pros & Developers. It's quick & easy.

An expression of non-boolean type specified in a context where a condition is expecte

P: 3
Using this Where statement I get the error " An expression of non-boolean type specified in a context where a condition is expected".
Expand|Select|Wrap|Line Numbers
  1. (PAT_ENC.CONTACT_DATE between team.CARE_TEAM_START_DT and team.CARE_TEAM_END_DT) or 
  2.               (PAT_ENC.CONTACT_DATE >= team.CARE_TEAM_START_DT and team.CARE_TEAM_END_DT isnull )
If I leave off the or statement I can get it to run, but I have some data that only has a start date. How do I get that in my query?
Jul 9 '13 #1

✓ answered by ck9663

I think you mean IS NULL instead of ISNULL. Rememeber, IS NULL is a condition statement while ISNULL() is a function.

Happy Coding!!!!


~~ CK

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,430
Please use code tags when posting code.

It's is null not isnull.
Jul 9 '13 #2

ck9663
Expert 2.5K+
P: 2,878
I think you mean IS NULL instead of ISNULL. Rememeber, IS NULL is a condition statement while ISNULL() is a function.

Happy Coding!!!!


~~ CK
Jul 9 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more Microsoft SQL Server Questions on Bytes