I am trying to change zero-length strings to Null on a table. How do i do this.
A alwaweru May 1, 2008 #1 I am trying to change zero-length strings to Null on a table. How do i do this.
K KARL DEWEY May 1, 2008 #2 Use an update query. First backup your database. UPDATE Mark SET Mark.status = Null WHERE (((Mark.status)="")); Substitue your table name for Mark and your field name for status.
Use an update query. First backup your database. UPDATE Mark SET Mark.status = Null WHERE (((Mark.status)="")); Substitue your table name for Mark and your field name for status.
