how to fetch negative sign data using select statement

[Former Member]

hi gurus,,

i hv to fetch data which is negative in nature using select statement i m using ppdit table and wrbtr field.(it contains both negative and positive data)....wat sud i add with select statement...plz help me..

thnx in advance

Message was edited by:

[Former Member]

Select * from ppdit into

where wrbtr < 0.

[seshatalpasai_madala]

HI,

I think you can use LT or < 0.0 in the WHERE clause to get all the -ve values. Once you get them treat them as negative.

Regards,

Sesh

[Former Member]

in your select staement where clause give where wrbtr lt 0.

regards

shiba dutta