Set Blanks to Null 1

[njvsummit]

I've inherited a rather large table that has several columns which contain both blank and null values. The table is not updated, just reported against. For consistencies sake, I would like to set all of the blank values to null. Is there an easy way to do this?

Thanks

 

[john76]

Try this:

Update MyTable
  Set   MyField = Null
  Where	Len(MyField) = 0

HTH,
John

 

[njvsummit]

I love simple solutions.

Thanks