I need to sql assistance with a field in my table. The field in the table is Pay_rate. It's a varchar(12) in the table. The problems is the result. The field looks like the below in the table.
I would like for it to look as such.
Any help is greatly appreciated. I tried the below, but it didn't work.
CAST(PPWG.PPWG_PAY_RATE AS NUMERIC(12,0)) AS RESULT