returning a boolean in a user defined function

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

returning a boolean in a user defined function

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-04 : 08:07:22

Phil writes "How can I rewrite the folowing function to make it return true, or false, based on the critiria I've given it?

Thanks,
Phil

Create Function dbo.CheckLOJStatus (@RequestNumber int)
returns
--WITH SCHEMABINDING
As
Begin

declare
@stepnumber int,
@cost real

select @stepnumber = stepnumber
from request_status
where requestNumber = @RequestNumber

select @cost = cost2
from request_status
where requestNumber = @RequestNumber

if @stepnumber < 3
return true
else if @stepnumber = 3 and @cost > 2999.99
return true
else if @stepnumber = 3 and @cost < 3000.00
return false
else if @stepnumber = 4 and @cost > 2999.99
return true
else if @stepnumber = 4 and @cost < 3000.00
return false
else if @stepnumber >= 5
return false

End"

Nazim
A custom title

1408 Posts

Posted - 2002-04-04 : 08:18:24

select @stepnumber = stepnumber ,
@cost = cost2
from request_status
where requestNumber = @RequestNumber

if @stepnumber < 3
return true
if @stepnumber = 3
begin
if @cost > 2999.99
return true
else
return false
end
if @stepnumber = 4
begin
if @cost > 2999.99
return true
else
return false
end

if @stepnumber >= 5
return false

HTH

--------------------------------------------------------------

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-04-04 : 08:30:00

True? False? What are they? SQL Server doesn't have a boolean data type.
You'll have to return it as a numeric type (preferably 0 and 1 as bit) and then test the return value again outside the call.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources