Seems a little odd but here are two ways you could do it. The first is a **ACK**Scalar Function**ACK**, the second is much the same logic but as an inline table valued function. In both cases I am using a property of the implicit conversion to bit. If the value is >= 1 the value of a bit will always be 1. 😉

create function Rule71

(

@ID_Wells int

)

returns bit as begin

declare @TrueFalse bit

select @TrueFalse = COUNT(*)

FROM Wells

WHERE Wells.ID_Wells = @ID_Wells

AND Wells.ClassificationID = 3

return @TrueFalse

end

go

create function Rule71_itvf

(

@ID_Wells int

)

returns TABLE

as

RETURN

select CAST(COUNT(*) as bit) as MyResult

FROM Wells

WHERE Wells.ID_Wells = @ID_Wells

AND Wells.ClassificationID = 3

end