Don't store data as strings, unless they genuinely are and will always be treated as, strings. Name, Addresses, phone numbers - they are all strings.
"1-8", "1-25" and so forth aren't, because you want to treat them as numbers in order to find out if something is in a range.
So store them as two separate numbers!
LeadID LeadMin LeadMax
0 1 8
1 9 25
2 26 50
...
Now, your problem becomes trivial:
SELECT LeadID FROM MyTable WHERE value BETWEEN LeadMin AND LeadMax