How to remove characters from a number field

[netcert]

I have a field that was incorrectly set as a number field then data was put in that field, needless to say numbers like 219615 ended up like 219,615.

Question is what is the syntax to go thru and update each number in those fields so the number looks like 219615? I plan to change the field type to integer or char then updating the fields, or is there a better way of doing all this?

Thx.

 

[dbomrrsm]

depends if there are only , in there if so you can do

update yourtable
set yourfield = replace(yourfield,',','')

[blue]DBomrrsm[/blue]

 

[dbomrrsm]

then change the datatype of the field

[blue]DBomrrsm[/blue]