Then it seems there is no difference between the OR and AND operator. I thought the AND operator would fulfill either both the conditions or nothing. Correct me if I have got this wrong.
Hi @priyesh41098
The syntax is correct, but the logic of the mask as you put it correctly produce nulls (because no index is between 1 to 4 and at the same time is either 7 or 8)! Null is the expected value.
Following is an example of using And, Does that help?