Does not return Integer properly

[benmillus]

I have a table (my.table):
Key Val1 Val2 Val3
xcv abc 1 2
sdf def 1 3

The query (select * from my.table) returns:
Key Val1 Val2 Val3
xcv abc 1.0 2.0
sdf def 1.0 3.0

Any ideas why and how to correct this?

 

[PHV]

In table design view have a look at the field size of Val2 and Val3

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886