My table includes a numeric field with data from 0 to 2 - but it also has empty fields. I'd like to increase all the numeric entries by one, but I don't want to change the blank values.
EMPTY() does not seem to differentiate between zeros and blanks, and the blanks don't seem to be nulls. LEN(STR(field)) doesn't do it, either!
How can I filter out the blank records from the replacement?
TIA
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site