473,385 Members | 1,320 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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

2 4260
Rabbit
12,516 Expert Mod 8TB
Please use code tags when posting code.

It's is null not isnull.
Jul 9 '13 #2
ck9663
2,878 Expert 2GB
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

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

Similar topics

3
by: Ton van den Heuvel | last post by:
Hi all, why does the following code not compile, and fail with: qed.cpp: In instantiation of `B<Foo*>': qed.cpp:40: instantiated from here qed.cpp:29: error: conflicting return type...
8
by: Bassem | last post by:
Hi to all... Thanks for the help... I want to get the value of the column of dataset into array, but I get this bug. "Cannot apply indexing with to an expression of type 'object'" when biuld....
3
by: Karel Vandenhove | last post by:
Hi, I get an error "cannot apply indexing with to an expression of type object" when I try to compile the code below. SSLScannerManager is a COM component. (Used to access fingerprint...
3
by: Adam J Knight | last post by:
Hi all, I am getting the following error with this if statement.. if(e.Item.DataItem != 2) { } //error Cannot apply indexing with to an expression of type 'object' Can someone fill me in on...
0
by: Anabela Silva | last post by:
To anyone who has experienced this problem! Could not find a property named '... ' on the type specified by the DataObjectTypeName property in ObjectDataSource '...' I've been looking at...
1
by: Allan Ebdrup | last post by:
I have a asp.net v2 website that runs fine on our development server. I have published the website to a stage server and it runs fine, but when I publish it to production I get the following error:...
6
by: Bob | last post by:
I'm not sure why this doesn't work... EACRank: IIf(>20,"1",IIf(<14.99,"3",IIf((>14.99) And (<19.99),"2"))) The first condition returns a 1 as desired. The second condition returns a 3 The...
2
by: pbd22 | last post by:
Hi, I am trying to create an update statement on a table with a foreign key to the Users table (userid). I am getting the error: An expression of non-boolean type specified in a context...
5
by: Satish | last post by:
When i compile this function I get the error Cannot convert lambda expression of type System.delegate because it is not a delegate type. private void SetStatus(string status) { if...
3
by: XolileWarren | last post by:
Hi Everyone I'm trying to create a stored procedure that will delete groups that are in-active for a month. Table description i have two table which are linked together using groupID, when...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.