Thanks for all the suggestions so far:
Im now using decimal fields for the price and adjusted the prices accordingly. I'm now using:
both:
template=staff_profile,staff_location=1119,@price_list.procedure_price>=1000.00,@price_list.procedure_price<=5000.00
and
template=staff_profile,staff_location=1119,@price_list.procedure_price>=1000,@price_list.procedure_price<=5000
Result in a profile with a price of 1500 being selected??
I really don't get why this is being so problematic. I really do want to use Processwire for this project but this filtering issue is giving me second thoughts