remove commas from a column data

Hello,
Loving this program. I came from Toad which was constantly crashing on me. One thing about this that bugs me is the addition of commas to all numbers in columns. Is there a way to remove commas from a specific column?

In sql server you can use REPLACE for remove data and STUFF to add data

as follows

replace('Your String','charater you want to replace','with what')

stuff('Your String',position,count,'data')

@dmikester1: I guess you mean integer and float columns, which are formatted by HeidiSQL in your local number format by default.

You can disable local number formatting in Tools > Preferences > Text formatting > "Local number format"

@ansgar: that did the trick, thank you very much!

in 10.1 Tools > Preferences > Text formatting > "Local number format" is not there.

Found it under:

Tools > Preferences > Grid Formatting > uncheck "Local Number Format"

I'm new to HeidiSQL and have never encountered such a setting in any SQL editor. I thought something was wrong with my query.

Still valid in how to disable it...

Tools > Preferences > Grid Formatting > uncheck "Local Number Format"