How to format a string field into number format in a select statement?

Analytics
Highlighted
Enthusiast

How to format a string field into number format in a select statement?

Hi, I have a field called "Cases". it's formatted as string. I want to convert it into number  into a select statement and sum it up. i tried  this but didn't work:

 

select SUM (Cast(Cases) as integer).

 

any help is appreciated

Tags (3)