I'm trying to use xp_fileexist against list of files. After reading the documentation I could find, I came up with the idea of creating a function then using it in the column list. The code previously displayed a list of filenames:

Not sure, but you don't need nvarchar(max), UNC paths are limited to 32K in Windows, and 260 characters for NTFS. And if you have a path that even approaches 4000 characters, your folder structure is waaaaaaaay too complicated.