var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Set full_address = level_floor + ' ' + Unit + ' ' + Street_Number + ' ' + Street_Name + ' ' + Street_postfix + ' ' +
Postcode + ' ' + Suburb
i'm trying to update a single field with a number of fields. It is still Null eventhough the update has run without errors
if any of the fields u r trying to concatenate is NULL, the result string will also be set to NULL. try using ISNULL(fieldname,'') in your UPDATE statement
SET full_address = COALESCE(level_floor + ' ','')
+ COALESCE(Unit + ' ','')
+ COALESCE(Street_Number + ' ','')
+ COALESCE(Street_Name + ' ','')
+ COALESCE(Street_postfix + ' ','')
+ COALESCE(Postcode + ' ','')
Just out of curiosity, is there a performance difference between ISNULL and COALESCE?
It looks to me like the ISNULL is a simpler function and it should be faster...
COALESCE is ANSI, ISNULL is not....
If you work with many different platforms...staying ANSI makes your life easier.
As far as being faster...COALESCE does more so it may be. Also, ISNULL is made for the SQL Server platform, so it may be architected to be optimized...don't know...
I do know you would be hard pressed to find a measurable difference...