query

i have a table call Table1 with the following data

Field Name ( Value ) with datas as follows

1

-1

2

3

-4

i want a query which display data as follows
PositiveNo Negative No
1 -1
2 -4
3

Hi,

select 'Positive No' =
CASE WHEN Value < 0 THEN ''
Else
Value
END,
'Negative No' =
CASE WHEN Value > 0 THEN ''
Else
Value
END
from Table1
But Output is coming like this
Positive No Negative No
0 -1
2 0
3 0
0 -4
5 0