Hi, I have a doubt in MS SQL, The below condition in the WHERE clause as you can see,
"Where COTDetails NOT BETWEEN 32 AND 63 OR COTDetails is NULL",
I want to the WHERE clause in such a way that the COTDetails is not between 32 and 63 and also is NULL, OR condition does not satisfy my condition.
Any help appreciated
arunkumars
14
Junior Poster
Recommended Answers
Jump to PostHave a look at this Click Here.
Also do WANT to select COTDetails that are NULL or that are NOT NULL ?
Jump to PostIs COTDetails a column in a table ? if so do the following for where clause:
WHERE COTDetails NOT BETWEEN '32' AND '63';
This works for me when selecting customers using their ID column.
Also don't forget to put " " on each end of your …
All 5 Replies
ChrisHunter
152
Posting Whiz in Training
Featured Poster
arunkumars
14
Junior Poster
ChrisHunter
152
Posting Whiz in Training
Featured Poster
arunkumars
14
Junior Poster
ChrisHunter
152
Posting Whiz in Training
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.