Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing only blank fields
Message
 
 
To
16/01/2003 19:48:44
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00742691
Message ID:
00742860
Views:
12
Thank you Hilmar! I appreciate your help!
Max


>The problem here is that, if you have SET EXACT OFF, all fields will meet >the condition. If you have SET EXACT ON, none will.

>If you know that the character field has 10 spaces, you can use:

>... where Field = space(10)

>However, the easiest method is:

>... where empty(Field)

>This works for most data types! Characters with only blank, memos that are >either empty or only blanks, numerics = 0, empty dates.

>Hilmar.
Previous
Reply
Map
View

Click here to load this message in the networking platform