Querying sybase servers through DTS

[TheJFM]

Hi all

I am querying a view (on a Sybase server) through a sql DTS.

One of the fields returned is a numeric field.

Some of the records return 0 even though there is a value in the field. When viewed through the DTS query builder preview a – is returned.

If I add convert function to varchar all the fields return a value.

When I query the same view through DBArtisan or in Access the true value is returned for all fields with no need to convert.

What is going on?


Thanks

** Don't reach for the moon when you have the stars. ;-) TheJFM **