>Hello all,
>
>I am trying to determine if a folder exist on my server.
>If the folder exist I would like to rename it.
>
>I know I can use the xp_fileexist extended procedure but I do not know how to determined if it is a folder.

See sample code below that shows how you can check for directory existence

CREATE TABLE #temp01 ( FileExists int, IsDirectory int, ParentDir int)
INSERT INTO #temp01 EXEC master..xp_fileexist 'C:\Program Files'
SELECT CASE IsDirectory 
	WHEN 1 Then 'Directory Exists'
	ELSE 'Directory doesn''t Exist or it''s a file' END
	FROM #temp01
DROP TABLE #temp01