Stored procedure, default value problem 1

[mrdance]

I have the default procedure below. I would like to return 0 if the sql can't find any voucherkey = @key.

How do I do that? Thanks!

CREATE PROCEDURE usp_verifyvoucherkey
(@key varchar(8))
AS
DECLARE @id int
SET @id = (
SELECT isvalid
FROM voucherkeys
WHERE voucherkey = @key)
RETURN @id
GO

--- neteject.com - Internet Solutions ---

 

[JamesLean]

CREATE PROCEDURE usp_verifyvoucherkey
  @key varchar(8)
AS

DECLARE @id int

SELECT @id = isvalid
FROM voucherkeys
WHERE voucherkey = @key

RETURN ISNULL(@id, 0)
GO

--James