How to check a file exist on a particular path or not

/*provide you information that given file exists or not, file is a directory or not,
is there is any parent directory of file*/

EXEC xp_fileexist filpath

for eg. you have to check noname.txt file exsist on your c drive root or not

then
EXEC xp_fileexist 'c:\noname.txt'