T-SQL function to check whether a file exists

Fileexists.sql

-- =============================================
-- Author:		Rohan Shenoy
-- Create date: 2013-10-28
-- Description:	Function to return whether file exists
-- =============================================
CREATE FUNCTION [dbo].[fnFileExists] (@path varchar(512)) RETURNS BIT

AS

BEGIN
	
	DECLARE @result INT
	
	EXEC master.dbo.xp_fileexist @path, @result OUTPUT
    RETURN cast(@result AS BIT)

END


GO