ELSE IF statements

[darkminos]

Hi I have a stored procedure which returns DBNULL if "Line" is empty rather than returning "EquipmentNumbe r":

ALTER PROCEDURE [dbo].[sp_get_distinct_lines]
@Department varchar(50)

AS

IF EXISTS (SELECT Line FROM Equipment WHERE Department = @Department)

SELECT DISTINCT Line FROM Equipment WHERE Department = @Department

ELSE 

SELECT DISTINCT EquipmentNumber FROM Equipment WHERE Department = @Department

Error messege "Unable to cast object of type 'System.DBNull' to type 'System.String' ."

[darkminos]

OK, found the answer myself....

IF (SELECT COUNT(Line) FROM Equipment WHERE Department = @Department) = 0
BEGIN 
SELECT DISTINCT EquipmentNumber FROM Equipment WHERE Department = @Department
END

ELSE
BEGIN
SELECT DISTINCT Line FROM Equipment WHERE Department = @Department
END