Mike check the other anwers but keep in mind that the FILE function search also in the PATH
i.e. You want to know if the file TEST.TXT exists in current directory but file with that name exist in c:\test and Your PATH env. is set to it
SET PATH TO c:\test
? FILE("Test.TXT")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
