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
  IF (@cod='999') SET @cod = '%' 
  IF (@prov='99') SET @prov='%'
  IF (@comune='9999') SET @comune='%' 

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) AND (COMUNE LIKE @comune) and (COD LIKE @cod) 

RETURN
END