"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:bc95hp$4dj$1_at_ctb-nnrp2.saix.net...
> Why should 'ABC'||NULL return null? Unless you a Ferengi dealing with the
> 66th Law of Acquisition (the one that deals with making money disappear),
> it makes no sense.
>
> You are not multiplying 'ABC' with NULL. You are not dividing it. You are
> saying : "ADD NOTHING TO THE STRING 'ABC'"
No you aren't, you are saying concatenate an UNKNOWN value to the string
'ABC', logically you can't do it. Not only that but it is possible that
'ABC'||NULL gives a different result everytime you run it. NULL isn't
NOTHING. If It were I'd be happy to use zero for NULL in numeric/date
datatypes.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jun 12 2003 - 12:00:54 CDT
