create function CreateCode(@name nvarchar(50))
returns varchar (9)
as
begin
declare @code varchar(9)
set @code =
(
select
case
when @name like '%ERTÜRK%' then 'Kod1'
when @name like '%POLAT%' then 'Kod2'
else 'KodYok' end
)
return @code
end
select dbo.CreateCode('ERTÜRK')
select dbo.CreateCode('POLAT')
select dbo.CreateCode('C#')
Yorumlar
Yorum Gönder