IF (SELECT COUNT(*) FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'FN_KARAKTERLISTELE') AND XTYPE IN (N'FN', N'IF', N'TF'))>0
BEGIN
    DROP FUNCTION [dbo].FN_KARAKTERLISTELE
END

GO

CREATE FUNCTION FN_KARAKTERLISTELE (@ISIM NVARCHAR(4000),@KARAKTER CHAR(1))
RETURNS TABLE AS
RETURN
SELECT 1 ID,T.C.value('.', 'VARCHAR(4000)') AS Numara 
FROM (SELECT CAST('<C>' + REPLACE(@ISIM,@KARAKTER,'</C><C>') + '</C>' AS XML) AS X) AS A
CROSS APPLY X.nodes ('/C') AS T(C)

GO

IF OBJECT_ID('tempdb..#TABLOM') IS NOT NULL
BEGIN
    DROP TABLE #TABLOM;
END;

CREATE TABLE #TABLOM 
(
 Id int IDENTITY(1,1),
 Adı  NVARCHAR(50),
 Kayıtno    NVARCHAR(100)
)

INSERT INTO #TABLOM
VALUES ('aaaa','1,3,5,9'),
       ('bbb','5,13,4'),
	   ('ccc','12,3')   

SELECT * 
FROM (
SELECT 
      T.*,
	  G.Numara 
FROM #TABLOM  T CROSS APPLY (SELECT Numara  FROM DBO.FN_KARAKTERLISTELE (T.KAYITNO,',')) AS G
     ) AS TMP
WHERE TMP.Numara = '5'