select TOP 1 (sth_exim_kodu),
When @EvrSeri <> ” Then RTRIM(sth_evrakno_seri) + ‘-‘
Else ”
END
Return +LTRIM(STR(sth_evrakno_sira))
FROM STOK_HAREKETLERI — WHERE sth_evrakno_sira=’253681’
/*
create FUNCTION [dbo].[fn_EvrNoSaykom] (@EvrSeri as nvarchar(6), @EvrSira as Integer)
RETURNS nvarchar(20) AS
BEGIN
Declare @Type as nvarchar(20)
Set @Type=Case
When @EvrSeri <> ” Then RTRIM(@EvrSeri) + ‘-‘
Else ”
END
