I get this error with the latest revision (containing the full path)
Msg 537, Level 16, State 2, Line 10
Invalid length parameter passed to the LEFT or SUBSTRING function.
Can't figure out why. Also it would be great to pull in the file date, can this be done as a field as well?
<hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh