Find * in query grid

[Alan]

how do I find an asterich in my record set and use an
update query to set the value to Null....In other words
remove the asterich? An asterich is the only character in
the field.

 

[Douglas J. Steele]

UPDATE MyTable
SET MyField = NULL
WHERE MyField = "*"