On the product FLEX ODBC, does some command that

substitutes the null value for zero in a consultation

exist? 
 
Example in Oracle 
nvl(x,0)  
or 
decode(x,null,0,x). 
 
Thank you. 
Miranda, Aracelia 
Brazil.

You can use:

SELECT Name, IsActive FROM ItemInventory WHERE Color IS NULL

however, you need to setup how empty strings are handled first:

yes, but I would like a command in the clause SELECT, I don't want to restrict lines. 
In the return of a consultation for instance: 
 
TABLE X 
Cod   Name       Invt 
  1        ANA              
  2        PETER       2  
  3       JONH          9  
 
in the first registration of that consultation where there is not registration in the column " Invt ", or be where it is null, I want some to come type of value for instance 0(zero). 
 
Example of the Command in Oracle: 
select Cod, 
             Name, 
             nvl(Invt,0) as Invt  
from    TABLE X 
 

Result:

TABLE X 
Cod  Name        Invt   
  1      ANA              0 ==> he/she sees the result as it was 
  2      PETER         2    
  3      JONH            9    
 
Thank you.