i have a folder where it could contains multiple files...
How can I know if a file or more exists without giving the extension ?
I know there is exec master.dbo.xp_fileexist [@stringname]
but i need to put extension...
here in my example I would like to see that if I search with the name EE001 well it exists because there is a .doc and a .pdf
any idea ? I tried exec master.dbo.xp_fileexist "EE001.*" but does not work