formatting a number

[expired user #8027]'s profile image [expired user #8027] posted 10 years ago in General Permalink
Hi just I would like to format the result of my Sql query like this
21 000 000 instead of 21.000000 i dont wanan use the (.) to separate
Please if you have some ideas let me know
ansgar's profile image ansgar posted 10 years ago Permalink
That's a Windows settings. Go to regional settings in your control panel and change it. HeidiSQL uses that as soon as you restart it.

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