I have a view and query it like:
Code:
select ...
TRIM(REPLACE(amsl,'meters',''))*1
.. from view
this gives 17

Then I save the upper query as new view and run it and instead of 17 I get
0x3137

?