goldmine NULL in history

Customer sees the word NULL in all history and cal records which had empty notes.

Any ideas to remove the word NULL from the notes ?

Thanks, bob

As posted on your other question

update CONTHIST set NOTES = 0x00 where NOTES is null

Select allOpen in new window

You can use this for any other table that has a Image type field

Would this work as well?

update conthist set notes = '' where Notes='NULL'

Select allOpen in new window

No. Null is a state not a value

And the note field is an image so you cannot set a string value

Right... I was just trying to account for the fact that the users are seeing that word through the UI, as if maybe it was actually written into the db that way.

I believe the word null is written as a word.

This did not work by GMGenius when I ran this:
update CONTHIST set NOTES = 0x00 where NOTES is null

Got this error when I ran this:
Msg 402, Level 16, State 1, Line 1
The data types image and varchar are incompatible in the equal to operator.

Any Ideas?

I kind of put this on the back burner but will be testing today.

I will keep you updated of the progress.

Have you experienced any of this during your upgrades? I see it often.

bob

Have you experienced any of this during your upgrades? I see it often

I've seen it, but only on one or two... I don't have a sense of what's causing it, but it is an odd feature.

still no resolve

@goldmineexpert... what do you mean "still no resolve?"

The solution I posted for you should work just fine! Did you not try it? If you leave the database with the word NULL in the notes field... well, yes, that's unresolved work you still need to do. But I'm not hearing that you tried my solution and it failed (which I promise you it would not!)