Null and concat

[Thorsten Hohage]

Hi Nobody,

On 2007-10-05, at 14:55, Bart Pietercil wrote:

> Hi Thorsten,
> On 5-okt-07, at 14:38, Thorsten Hohage wrote:
>
>> Hi Bart,
>>
>> On 2007-10-05, at 14:03, Bart Pietercil wrote:
>>
>>> SELECT CONCAT('Va’, NULL, ‘na’);
>>>
>>> crashes VStudio
>>
>> no - I got a "unexpected token NULL"
>>
>>> SELECT CONCAT('Va’, NULL)
>>> I get unexpected token NULL.
>>
>> same here and IMHO this is ok, because NOBODY would type a  
>> constant NULL in a concat statement.
>>
>
>
> call me NOBODY
done!

but ...

> ... Since objptr_organisation can be NULL my... (but mind you  
> objptr_organisation is NULL, so unique_name_organisation is also NULL)

you didn't TYPE "concat(..., NULL, ...)" as a constant! Of course  
some rows, or variables, or results, ... could be NULL but that's  
different, from what I've written. I didn't said anything about a  
value being NULL, only about a constant "NULL".

regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany