Hello,
I have a music database containing song BPM (Beats Per Minute) data values stored as FLOAT. I need to pull a range of BPM values based on a user-supplied integer. The range should pull all records which are 8% higher and lower than the given integer. I tried this query for starters: SELECT * FROM test HAVING ( bpm < SUM(100 * 1.08) ) OR ( bpm > SUM(100 * .92) ) No errors appeared however only one row returned (with bpm value 55.03). There are approximately 100 records that have a bpm value between 92.00 and 108.00 in the "test" database. Am I overlooking something obvious?