I am looking for a function in SQL server similar to ADIR() in foxpro.

Does any body know how to get information about files into an array and then returns the name of the files.


Thanks,
Sergio