Hi! I'd appreciate your help validating this: How can I create a filter for a range of numbers in the clause WHERE? I want to filter numeric data between 1 and 3. I know we can use that clause "BETWEEN _ AND"; however, this works to bring up the range, but it doesn't filter the range to avoid that info.
Hi, If I understood your question correctly, you want to filter the data excluding numeric data between 1 and 3. If this is the case then you can use following in your where clause : "NOT BETWEEN 1 AND 3"
Hi!
I'd appreciate your help validating this: How can I create a filter for a range of numbers in the clause WHERE? I want to filter numeric data between 1 and 3. I know we can use that clause "BETWEEN _ AND"; however, this works to bring up the range, but it doesn't filter the range to avoid that info.
Hi, If I understood your question correctly, you want to filter the data excluding numeric data between 1 and 3. If this is the case then you can use following in your where clause : "NOT BETWEEN 1 AND 3"