Hi,



I'm at a complete loss on this problem and it's kind of scary.  I

am querying data from a Sybase database and I am getting unusual (to say the 

least!) results from my query.  If the data is numeric and it ends in a zero 

the zero is removed when the recordset results are returned.  I am using ADO 

2.6 and ASP or VB to query the data. This problem occurs only if I use ADO. 

Delphi developers are able to access it properly without any problem.



For example:

Sybase data to recordset results

1394 returns 1394 - results are correct

500 returns 5 - results are incorrect

1390 returns 139 - results are incorrect

20 returns 2 - results are incorrect



Regards,

Pugal.



Can anyone help me?