Re: How to obtain results looking for a NULL

[el...@accenture.com]

To Brandon Goodin
 
The prepend="OR" doesn't works; and I don't want the next:
Example: A='2' B=null
SELECT A, B FROM ME 
    WHERE A='2'
            OR B IS NULL
I want AND, and then B='3' (for example) or B IS NULL.
 
Thanks for the answer.
 
 
To Brice Ruth
 
I don't try that, but I supose yes. How can that case be connected with
my problem?
 
Thanks for your answer too.
 
 
 
 
 
 


This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information.  If you have received it in error, please notify the sender immediately and delete the original.  Any other use of the email by you is prohibited.

Re: How to obtain results looking for a NULL

[Brandon Goodin <br...@gmail.com>]

Then i'm not completely sure what you are asking for. Write out your
SQL statement in it's most complex form without tags. Just write
straight SQL. If you do that i think i'll understand what you are
wanting.

Brandon

On 5/5/05, eloy.garcia.b@accenture.com <el...@accenture.com> wrote:
>  
> To Brandon Goodin 
>   
> The prepend="OR" doesn't works; and I don't want the next: 
> Example: A='2' B=null 
> SELECT A, B FROM ME  
>     WHERE A='2' 
>             OR B IS NULL 
> I want AND, and then B='3' (for example) or B IS NULL. 
>   
> Thanks for the answer. 
>   
>   
> To Brice Ruth 
>   
> I don't try that, but I supose yes. How can that case be connected with my
> problem? 
>   
> Thanks for your answer too.
>  
>   
>   
>   
>   
>  
>  
> 
> 
> 
> 
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited.