Re: Query/400: How do you create a numeric field with specificcharacteristics?

Hi Lucus, Lisa and other Mapics ML members:

Thank you for your suggestions.  They have been helpful
and I'm getting closer to a solution to my Query/400
problems.

I have some additional questions:

Query # 1 produces a numeric field called EMPNO (Len 5,
Dec 0) that displays on F13 (Layout), as follows:

EMPLOYEE
 NUMBER
  99999

Query # 2 produces a numeric field called EMPNO (Len 5,
Dec 0) that displays on F13 (Layout), as follows:

EMPLOYEE
 NUMBER
 99,999

These fields are both "numeric" fields and have the same
Len and Dec settings.  Why does one have a comma separator
and the other doesn't?

How do I revise Query # 2 so that the comma separator is
removed?

Al Gershen
Grants Pass, OR
aldg1@charter.net