Edited higher limit, then saw the wrong signs in the range.
Initial query:
select * where (RadTransWavelength >= 1.9986163866666667E7 AND RadTransWavelength <= 2.99792458E7) AND ((InchiKey = 'JJWKPURADFRFRB-UHFFFAOYSA-N'))
Result query:
select * where (RadTransWavelength >= 4.0 AND RadTransWavelength <= 1.9986163866666667E7) AND ((InchiKey = 'JJWKPURADFRFRB-UHFFFAOYSA-N'))
Edited higher limit, then saw the wrong signs in the range. Initial query: select * where (RadTransWavelength >= 1.9986163866666667E7 AND RadTransWavelength <= 2.99792458E7) AND ((InchiKey = 'JJWKPURADFRFRB-UHFFFAOYSA-N')) Result query: select * where (RadTransWavelength >= 4.0 AND RadTransWavelength <= 1.9986163866666667E7) AND ((InchiKey = 'JJWKPURADFRFRB-UHFFFAOYSA-N'))