the function ThousendSeperator_FN am using to add a thousend seperator for a number like:
select dbo.ThousendSeperator_FN('1234567')
and the result 1,234,567
--
to execute the procedure as the following:
exec dbo.PathDBFile_SP 'c:'
this procedure will search for any database file in c:\ and its sub directory.
