If else in a Storep Procedure

[Micke101]

Hi

I'm trying with the an sql query get a recordset and
to return a name for ex

select name,adress,number1, number2 , number3

if numer1 + number2 > 0
begin

select 'BiggerthanZero' as ReturnName
end
else
begin

select 'LessThanZero' as ReturnName
end

FROM TableName

this doesn't work what im a doing wrong or is
it impossible to return a recordset and the 'ReturnName'

Micke