replacing a character field with a blank 2

[maggielady]

I have a field that has a character 0 (zero) in it. I would like to make that field blank when there is a 0 in it. I tried to replace the field with " ", "" and nothing works. My brain is fried today, could someone please help?

 

[craigsboyd]

replace mytable.myfield with "" in "mytable" for mytable.myfield = "0"

...the above code is assuming that the table is open and that the field is of character data type.

http://www.sweetpotatosoftware.com

 

[torturedmind]

you can also use

BLANK FIELDS mytable.myfield FOR mytable.mfield = "0"

hope this helps. peace!

kilroy
philippines

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get one million miles to the gallon, and explode once a year, killing everyone inside."