Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Diff between 0 and blank in numeric field
Message
From
22/10/1999 17:27:22
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00280270
Message ID:
00280288
Views:
16
For Numeric data type you could use ISBLANK(), but for Integer.. I don't know.

>Well, I'm just gonna avoid using Zeros for data - but at the moment I'd like to avoid modifying data by hand. Since they're not nulls, any way to differentiate betwixt zeros and nothin?
>
>>>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
>>
>>You may better use .NULL. to get true and safe difference.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform