pj (peterjohannsen@hotmail.com) writes:
> Why does M$ Query Analyzer display all numbers as positive, no matter
> whether they are truly positive or negative ?
>
> I am having to cast each column to varchar to find out if there are
> any negative numbers being hidden from me
>
> I tried checking Tools/Options/Connections/Use Regional Settings both
> on and off, stopping and restarting M$ Query Analyer in betwixt, but
> no improvement.
>
> Am I missing some other option somewhere ?

I have never had any problems with QA not showing negative numbers.

If you run your query from command-line ISQL, do you seen negative
numbers there?


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp