Re: Is there any way to check for a field with nothing in it?

On 31/07/16 15:37, bit-naughty_at_hotmail.com wrote:
> On Saturday, July 30, 2016 at 12:41:26 AM UTC+5:30, Gordon Burditt wrote:
>
>> WHERE columnname is null
>
>>
>> WHERE column1 is null and column2 is null and column3 is null ...
>>
>
> You keep writing "null" in LOWER case - doesn't it have to be in *capitals*?
>

SQL is not case sensitive in general, though it can be made to be in some implementations

-- 
The biggest threat to humanity comes from socialism, which has utterly 
diverted our attention away from what really matters to our existential 
survival, to indulging in navel gazing and faux moral investigations 
into what the world ought to be, whilst we fail utterly to deal with 
what it actually is.