If else in a stored procedure and returning a recordset

[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

[Lafor]

Q.
1. Your select, does it return more than 1 record?

do you expect it to?

In any case, you could return it as part of the recordset

select name, add,num1, num2, num1 + num2 as desiredfield

and check your recordset later one for desired field

if RS.fields("DesiredField") > 0 then


assuming RS is your recordset..

good luck