That looks perfect and seems to produce the right results.

Thanks Phil

Very true..

I did amend the insert value as suggested.

Many thanks

select @recordid = recordid from inserted

The OP will find out soon enough what the problem is when they attempt their trigger with more than 1 row :w00t:[/quote]

Thanks for the...

Thanks for your input guys

I ended up doing the following

declare @MD varchar(100), @SD varchar(100), @Path varchar(100), @recordid varchar(10)

set @recordid = (select recordid from inserted)

SET@Path = 'C:\MyTestPath\'

SET@MD =' mkdir '...