I was able to modifiy this and get it to do what I want. Thanks for all your help. This was a life saver!

Thanks

Dave

noeld, thanks for your help. I think we are getting close here.

Not, I guess my noviceness of MS SQL is going to come out now, but how would you insert...

I am using SQL 7 for this, I did find there is an Extended Stored Procedure named xp_varbartohexstr in there, but I have not been able to get this to...

I'll try to put the request in another way. How do you export a blob into hex form?

Maybe that can get my result I am looking for.

Thanks

Dave