Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Mustapha Bihmouten
  Where is Mustapha Bihmouten?
 Casablanca
 Morocco
 Mustapha Bihmouten
 Tags
Subject: RE: Filtering .NULL.
Thread ID: 112408 Message ID: 112418 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, November 08, 2006 11:52:16 AM         
   


> Hi Christian
>
> Not sure what you want to do
>
> But you can use
isnull()
function to check the fields
>
>
> Mustapha Bihmouten


In VFP9 SQL, you can also use the IS NULL statement:
SELECT yourfields ;
FROM yourtable ;
WHERE somefield IS NULL ;
	AND NOT otherfield IS NULL ;
INTO CURSOR result

--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

ENTIRE THREAD

Filtering .NULL. Posted by Christian Tabligan @ 11/8/2006 10:18:54 AM
RE: Filtering .NULL. Posted by Mustapha Bihmouten @ 11/8/2006 10:34:34 AM
RE: Filtering .NULL. Posted by Eric den Doop @ 11/8/2006 11:52:16 AM
RE: Filtering .NULL. Posted by Christian Tabligan @ 11/9/2006 1:32:39 AM