Get DB Files in directoy

CREATE PROCEDURE [dbo].[PathDBFile_SP](@SearchPath VARCHAR(200))
AS

BEGIN
 DECLARE @exec INT
 SELECT @exec = ToBeExecuted
 FROM ProcedureConfiguration
 WHERE ProcedureName = OBJECT_NAME(@@PROCID)
 IF ( @exec = 1 )
 begin
SELECT * INTO ##temp236 FROM sys.[database_files]
EXEC sp_msforeachdb'insert into ##temp236 select * from [?].sys.database_files'

DECLARE @path VARCHAR(200)
SET @path=@SearchPath
SET @path=REPLACE(@path,'''','')
IF ((SELECT SUBSTRING(@path,LEN(@path),LEN(@path)-1)) NOT LIKE '\')
BEGIN
    SET @path=@path+'\'

END


    SET @path=@path+'%'
    SELECT DISTINCT physical_name AS FilePath,[name] AS DBName,
    dbo.ThousendSeperator_FN([size]) AS FILESize
    FROM ##temp236
    WHERE physical_name LIKE @path
    ORDER BY 3
    
    DROP TABLE ##temp236
    END
    ELSE 
 BEGIN
 PRINT 'The Procedure couldnt be executed please check the configuration table'
 END
    END