var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concatination of strings having either value NULL
In IBM DB2 for concatenation query as:
'SELECT FIRST_NAME || MID_NAME || LAST_NAME AS NAME FROM INFO'
If either of the 3 values is NULL, I get the concatenated string as NULL....Is there any way that I get the correct result string (Not NULL) even if any value is NULL??
Thanks in advance,
You can try the following query. I have just put the values 9,5,9 etc. In your case you put some logical values against them depending upon the datatype length.
'SELECT CHAR(COALESCE(FIRST_NAME,''),9) || CHAR(COALESCE(MID_NAME ,''),5) || CHAR(COALESCE(LAST_NAME,''),9) AS NAME FROM INFO'
Thnx a lott Jayanta...
The query worked...