Quick question,

I am using the following line to update a numeric field I created witht the ALTER TABLE command:

UPDATE cliqcnv SET pcb=VAL(cpcb.totalpcb) WHERE ;
VAL(cpcb.totalpcb) > 0

However, when the field equates to ZERO I want it to be empty, not contain the number zero. I have tried setting NULL on before creating the field. All I get is .NULL. in the field, and when I export it to a comma-delimeted file(which is my final goal), the result is zero(0). I need it to be NOTHING.

The field I am converting from, "totalpcb", is a character field that contains things like "<1" or "<2". I want the records with these field values to contain nothing when converted to numeric.

Help always appreciated.
Thanks.
Elgin Rogers
Epic Solutions