remove commas from a column data

dmikester1 posted 3 years ago in General
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?
Emma Taylor posted 3 years ago
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')
ansgar posted 3 years ago
@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"
dmikester1 posted 3 years ago
@ansgar: that did the trick, thank you very much!
danoldenkamp posted 2 weeks ago

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

Found it under:

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

Please login to leave a reply, or register at first.