Sample code for a function


SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fn_sample]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[fn_sample]
GO

CREATE FUNCTION dbo.fn_sample(@arg1 VARCHAR(11), @arg2 VARCHAR(11))
RETURNS varchar(64) AS

begin 
	return null;
end



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO