You could map your values like
old, dual(old, number) AS new
Then in your survey table, use something like
ApplyMap('MAP', response) AS response
I've used a dual value, so you have both text and number at hand, using num() or text().