Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Converison to numeric type ?
12-15-2013, 05:39 PM #1
- Join Date
- Dec 2005
- Thanked 79 Times in 79 Posts
Converison to numeric type ?
Have a field 'amsl' of type text, with empy string in it
(CASE WHEN amsl = '' then NULL else (TRIM(REPLACE(amsl,'meters',''))*1) end) as amsl1
Should not then there be Null if source data is '' ? Instead I get 0.
btw, if I do
(CASE WHEN amsl = '' then '' else (TRIM(REPLACE(amsl,'meters',''))*1) end) as amsl1