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"
![TEEDEE TADA - DIAMOND NARAKORN X LEGO LYKN [Special Dance Performance]](http://i.ytimg.com/vi/QgtZedFeumA/mqdefault.jpg)
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"