Integer format without comma

[salvadormarchan]

Hi All,
I created a field within a certain table having an integer data type. I tested the value and it automatically provides a comma after every 3 decimal places.

Question: How do I disable this? We don't want the comma. I tried looking at the wiki (and googled it) but no avail.

Thanks,
Dor
(Day 45)

[Mark Stanger]

I don't know off the top of my head, but I'm curious why you don't want commas if the value in the field is an integer. Are you going to be performing mathematical operations on those values? Maybe what you're looking for is a String field instead.

[salvadormarchan]

In terms of reporting (back-door operation in SQL Server...NOTE: long story to tell), there are SQL statements in place where by this field is set as integer. Setting the data type to string works to avoid the comma but there will be changes in the SQL statements.
At the interface, other users prefer without commas but setting it to string data type allows non-numeric characters.
[Honestly, I have a lot of "shake-ur-head" issues here...:-) I need a drop of beer to tell all one-by-one...]

[salvadormarchan]

.......and also, sorting numeric vs string will give different results.

[salvadormarchan · Accepted solution]

I have overcome this dilemma weeks ago. I am now writing it to share with you...

What I did was created another field having Integer datatype along with the required field that should have no comma (chosen data type is String); In the form, I created a section called 'Admin Use' and created a client script that hides it from non-admin users. The Integer field is in this section. So, when I perform import, I populate both fields. One for Business Analyst's use and one for us (Admin). SO, I can sort records with an integer-behaviour and not a string-behaviour.

If there's another way of doing this, please let me know. Thanks.