A subtlety I missed!

Thanks, John.

Thanks, John.

But I want to build this into a script or procedure. I found a solution that works:

IF object_id('dbo.Table1') is not null DROP table dbo.Table1

I'm...

Thanks Flo.

It's good to know that I can use a function. I guess I'll have to accept that I can't do what I want in the procedure.:crying:

Buz

Thanks! I investigated a little further and this works also:

ALTER PROCEDURE [dbo].[IsActiveUser] (@CustID int, @res bit OUTPUT)

AS

IF EXISTS (Select * from Customer where CustomerID = @CustID)...