CREATE FUNCTION dbo.f_test(@km varchar) RETURNS float AS BEGIN declare @ret_value float; select @ret_value=ye from TABLE where km like @km+'%' return @ret_value END
CREATE FUNCTION dbo.f_test(@km varchar(50) ) RETURNS float AS BEGIN declare @ret_value float; select @ret_value=ye from TABLE where cast(km as varchar(50) ) = @km return @ret_value END
RETURNS float
AS
BEGIN
declare @ret_value float;
select @ret_value=ye from TABLE where km like @km+'%'
return @ret_value
END
RETURNS float
AS
BEGIN
declare @ret_value float;
select @ret_value=ye from TABLE where cast(km as varchar(50) ) = @km
return @ret_value
END