CREATE PROC [dbo].[MALZEME_KODU_FILTRESI]
(@KOD VARCHAR(100))
AS
BEGIN
/*
DECLARE @SONUC VARCHAR(100)
DECLARE @KONTROL SMALLINT
SET @KONTROL = CHARINDEX('/',@KOD)
SET @SONUC = REPLACE(@KOD,'-','')
IF @KONTROL > 0
BEGIN
SET @SONUC = LEFT(@SONUC,CHARINDEX('/',@SONUC))
SET @SONUC = REPLACE(@SONUC,'/','')
END
SELECT * FROM [IHR].[dbo].[OEM_ILE_LISTELEME] WHERE REPLACE(CODE,'-','') LIKE '%' + @SONUC + '%'
*/
SELECT * FROM [IHR].[dbo].[OEM_ILE_LISTELEME] WHERE CODE = @KOD
END