BETWEEN can certainly be used with strings, but ...
Are you saying you are storing prices in VARCHAR fields? If so, then BETWEEN would most likely return incorrect results, as the string '123.45' is "less than" the string '45.67'.
If possible, monetary amounts should be stored as integer fields, for example €123.45 would be stored as 12345. This method gives the best accuracy and speed. You can then use tweenerz's solution, possibly dividing the prices by 100 before displaying them.
-----
ALTER world DROP injustice, ADD peace;