create or alter function [dbo].[esDependiente](@p_id int) returns bit as begin declare @res bit=0 if exists(select 1 from cat_atributo_opcionatributo where id_atributo=@p_id and active=1) set @res=1; return @res end