SQLServer过滤文件名特殊字符（利用SQLServer修改文件物理地址名称）

declare @cmd nvarchar(2000)
    declare @messageid nvarchar(200)
    declare @serialid nvarchar(200)
    declare @oldFileName nvarchar(500)
    declare @fileName nvarchar(500) 
    declare @filePath nvarchar(4000)
    declare @oldfilePath nvarchar(4000)  --将路径D：改成D$
    declare @newFilePath nvarchar(4000)
    declare ccur cursor for select d.MessageId,m.serialid,m.AttachmentName,m.AttachmentPath from d 
			left join r on d.MessageID=r.MessageID 
			left  join DataAttachment m on m.MessageID=d.MessageID 
		where  d.messageid='0.abe3b3d58161ccb3de7ab63754bb3f15'  --通过数据库查找所需要的附件
	             open ccur
	             fetch ccur into @messageid,@serialid,@fileName,@filePath
	             while @@fetch_status=0
                 begin
                    --判断附件文件名中是否含有特殊字符 
                    if CHARINDEX('+',@filename)>0 or CHARINDEX('$',@fil