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?