********* Null + 'String' = Null !!!!!!! why, why, why!!!!!!!! 
Author Message
 ********* Null + 'String' = Null !!!!!!! why, why, why!!!!!!!!

 Null  +  'String'  =  Null !!!!!!!
SQL Server version 7

concatanating Null with a string will result in NULL!!!! Does not make sense
common-sense-wise!!!
Is this a bug? Any patches!

MY SOLUTION:
I  thought about making a view on tables that have Nullable columns to
convers Nulls  using a case statment.

DO YOU HAVE A BETTER SOLUTION?

TIA



Sat, 29 Mar 2003 03:00:00 GMT  
 ********* Null + 'String' = Null !!!!!!! why, why, why!!!!!!!!

Quote:

> Null  +  'String'  =  Null !!!!!!!

+ is an addition.  For concatination, use &, ie, Null & "" = ""

Null plus anything is Null; Null concatinated to a string gives a string.



Sun, 30 Mar 2003 09:34:23 GMT  
 ********* Null + 'String' = Null !!!!!!! why, why, why!!!!!!!!

because null is a unknown value use something if value is null, value = ""
then your string concat will work.

Quote:

> Null  +  'String'  =  Null !!!!!!!
> SQL Server version 7

> concatanating Null with a string will result in NULL!!!! Does not make
sense
> common-sense-wise!!!
> Is this a bug? Any patches!

> MY SOLUTION:
> I  thought about making a view on tables that have Nullable columns to
> convers Nulls  using a case statment.

> DO YOU HAVE A BETTER SOLUTION?

> TIA




Fri, 04 Apr 2003 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. why why why why

2. Why why why why?

3. Why oh why doesn't this work?

4. Why Microsoft, why'd ya do it?

5. Why Why Why

6. ActiveX wont deploy to Win 2K - why, Why WHY

7. VB6 ListView: Why oh why oh why...

8. Why, Why, Why!!!!!!!!!!!

9. !Excel/VB: why why why?

10. Why,Why,Why are javabeans completely ignored?

11. VB6 ListView: Why oh why oh why...

12. Why my string variable can't be assigned with a value

 

 
Powered by phpBB® Forum Software