topic how to fetch negative sign data using select statement in Application Development and Automation Discussions

how to fetch negative sign data using select statement

Former Member — Thu, 01 Feb 2007 05:29:43 GMT

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:

Re: how to fetch negative sign data using select statement

Former Member — Thu, 01 Feb 2007 05:31:48 GMT

Select * from ppdit into

where wrbtr < 0.

Re: how to fetch negative sign data using select statement

seshatalpasai_madala — Thu, 01 Feb 2007 05:33:23 GMT

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

Re: how to fetch negative sign data using select statement

Former Member — Thu, 01 Feb 2007 05:33:26 GMT

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

regards

shiba dutta