-- =============================================
-- Create inline function (IF)
-- =============================================
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'TEST_F')
DROP FUNCTION TEST_F
GO
CREATE FUNCTION TEST_F
(
@p1 varchar(100),
@p2 int )
RETURNS varchar(100)
AS
begin
RETURN substring(@p1,1,@p2)
end
GO