"AA2e72E" wrote ...

I've never used Sybase.
If your query determines a column to be numeric (scanning n rows only)
and then finds that some rows have characters, those rows are lost.
You might consider researching SCHEMA.INI on Google.

I think you may have mistaken Sybase for a text file.

Jamie.

--