UPDATE Table1<BR>SET Field = NULL <BR>WHERE Field =''<BR><BR>I get<BR><BR>The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.<BR><BR>Any way out?
The problem is with your WHERE statement. You can't run that kind of comparison with text, ntext or image data types. Try:<BR><BR>WHERE Field IS NOT NULL<BR><BR>But ONLY do this if all your columns don't have data in them. If you have data in them that you need to preserve, don't use this method! Otherwise it will overwrite it all and that would kinda suck.
...some with data<BR>...some NULL <BR>...some = ''<BR><BR>I want to make the fields with '' into NULL, and I don't want to overwrite the field with data...<BR><BR>Any ideas?<BR><BR><BR>