TO_NUMBER(REPLACE('25.5%', '%', '')) would return...
# general
b
TO_NUMBER(REPLACE('25.5%', '%', '')) would return 25.5 in a saved search