Witango-Talk: Numeric Field Formatting??

[Cecilia Cos]

Hello,

So I have a numeric field in SQL 2000 and have the info below in an updatable record detail

<TR VALIGN=TOP ALIGN=LEFT>
        <TD>
                Packet Key #:
        </TD>
        <TD>
                <@COLUMN "PELog.KeyNo" FORMAT="num:,,,'@@decimalChar',,,'-',">
        </TD>
</TR>

but for some reason....the field keeps getting formatted and it comes out like this

Packet Key #: 123,123.00

but in the table it is 123123 which is what I want....

Any thoughts or suggestions?

Cecilia C. Cos
Data Analyst
Newsweek | 251 W 57^th Street | New York, NY | 10019
212-445-4309
[EMAIL PROTECTED]

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf