CREATE FUNCTION dbo.fn_RICERCA1 (@cod char(3), @prov char(2),@comune varchar(100) )
RETURNS @d TABLE (Nome VARCHAR(10), Prov VARCHAR(3), NewCod VARCHAR(10),Cod00 VARCHAR(2),Indirizzo VARCHAR(100),Cap VARCHAR(9),Comune VARCHAR(100),Attivo VARCHAR(2),Cod VARCHAR(3))
AS
BEGIN

INSERT INTO @d
SELECT DISTINCT Nome, Prov, NewCod, Cod00, Indirizzo, Cap, Comune, Attivo, Cod
FROM ANAG_N
WHERE (NewCod NOT LIKE '%*%') 
     AND (SIGLAS='I')
     AND ((Prov LIKE @prov) OR (@prov='99') OR (@prov='') OR (@prov IS NULL)))
     AND ((COMUNE LIKE @comune) OR (@comune='9999') OR (@comune='') OR @comune IS NULL))
     AND ((COD LIKE @cod) OR (@cod='999') OR (@cod='') OR (@cod IS NULL))

RETURN
END