I'm also a little amazed the OP says they're using SQL (Server?) Version 5, which I'm pretty sure never existed.  Even if it did, it would have been out of...

Your problem is that =NA() doesn't represent NULL. Even according to the documentation, it returns an error; which is represented by the text (important word there 😉 ) #N/A. To...

Quoting from Integration Services (SSIS) Logging:

You're going to need a lot more specific that this... A LOT more.

When you say "her database stopped working" are you saying that the SQL Server instance isn't...

I'm honestly not sure SQL Server is the correct answer to doing this. This is going to take A LOT more than a SUBSTRING. Especially if that error...

Try converting back to varchar, rather than nvarchar? If your initial string was a varchar, you need to convert back to that. For example:
SELECT CONVERT(nvarchar(100),CONVERT(varbinary,CONVERT(image,'sdfashgu3o4ggjkxchbvkjasgvftkj'))); --varchar to...

This might be easier with Extended Events on SQl Server 2012. I honestly can't recall if XE is available on 2008.

Thanks Eirikur, but that was the method I was trying to avoid, due to there being over 85 variations of the frame in the full data. The REPLACE method posted...

That's an SSMS error, not SQL Server. SSMS is a 32bit application, and thus is quite limited on how much memory it can address (can't recall if it's 512MB or...

OK, got it. My initial solution worked, but because the original data I had was also coming from XML, it was just overkill for the server. Instead, I put all...

Nevermind.