Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns940E62C4A482Yazorman@127.0.0.1>...
> 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?

I get nothing back with ISQL (using "select * from atestneg" from
my example posted in the other thread), but if I use OSQL, then
"select * from atestneg where dollars<0 order by dollars" yields me
the list of apparently positive numbers in descending order -- so
whatever ordered them understood that they were negative, but I don't
know if the client is getting them as negative and just showing
them incorrectly, or if the client is misunderstanding them as
positive.