CREATE  or alter PROC sp_FiyatGorStokDetay @barkodu nvarchar(80) 
AS BEGIN  
SET NOCOUNT ON;    
SELECT          
REPLACE(            
	REPLACE(                 
		REPLACE(                     
			REPLACE(ST.StokAdi, 'Ý', 'I'),'Ç', 'C'),  'Ü', 'U'), 'Ð', 'G') AS urunadi,     
ISNULL(STF.F4FiyatH, 0) * (1 + ISNULL(ST.SatisKdv, 0) / 100.0) AS fiyat   
FROM STOKKARTI ST     LEFT JOIN StokFiyat STF          ON STF.StokNo = ST.StokNo    
WHERE ST.StokNo = (         SELECT TOP 1 StokNo         FROM StokBarkodlari         WHERE Barkodu = @barkodu     ); END;

sp_FiyatGorStokDetay 1