Create Folder If Non Existent
You can use the extended stored proc "xp_dirtree".  Store the results in a temp table and get the rowcount.  Zero = not exists.  

create table #Files(
subdirectory nvarchar(512),
depth int)

insert into #Files
exec xp_dirtree 'c:\windowsX'

select @@ROWCOUNT

drop table #Files