VB & Database, ********* Null + 'String' = Null !!!!!!! why, why, why!!!!!!!!

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

Author	Message
F.K. #1 / 3	********* 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

Michael Col #2 / 3	********* 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

toddbaile #3 / 3	********* 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

Page 1 of 1

[ 3 post ]