in reply to Re: Re: Re: Thousands separator - this is getting annoying
in thread Thousands separator - this is getting annoying

That doesn't make any sense, unless, as agentM suggest, your number field is represented internally as a string.

Actually, it's likely that the database is storing the numbers as numbers, but that the format used when a number is retrieved from the database specifies commas. For example, in Oracle SQL*PLUS:

14:23:48 FOCX> desc mytable Name Null? Type ----------------------------------------- -------- ---------------- ID NUMBER(7) 14:23:56 DB> select id from mytable; Press <enter> to continue... ID ------- 1000 1001 14:23:59 DB> set numformat 999,990 14:24:06 DB> / Press <enter> to continue... ID -------- 1,000 1,001