thanks Vladan. I have run that and i have found particular data that cause the trouble. Some of those are in the forms of: '230453,50' and '1.000.000'

See, this suppose to...

yes, i have "clean" the non numeric data by adding the where keyword. [the A in this wr_id contains only numeric data but in varchar type]

so here's what i have...