0 - 2 of 2 tags for CAST DECIMAL

Casting as decimal with precision 2, keeps returning 00 after the decimal. How do I actually return values?

 

column1   hourlycolumn1

----------   ------------------

9797       163.00

358         5.00

265         4.00

 

select top 10

Trying to use REGEXP_INSPR to identify if a VARCHAR(50) column contains data that can be converted to Decimal(8,2) and if so convert it.  Below is my SELECT: