Hi,

Na. I tried and it wont work. It will bring the negative values too.

i checked with case and its working in select clause but not in where clause. thats the problem