Concatinating the String with NULL
Posted: Fri May 07, 2004 8:18 am
Hi,
I have a situation to concatinate a hardcoded string with another. Something like below:
'<ISP>':DSLink3.Table_column1:'</ISP> ':'<DI>':DSLink3.Table_column2:'</DI>
I have to pass this as one string per row in a table. But the problem is: if any of the above columns in a table(Table_column1 or Table_column2) is null...the whole string does not populate. I want to populate the string even if the column1 and column2 is null. Something like below:
<ISP></ISP><DI></DI> ---> I am tryign to achieve this in case of null values for columns Table_column1 and Table_column2.
Is there a way to concat the string with a null value.
I will really appreciate any advice and recommendation in this regards.
Thanks
Raj
I have a situation to concatinate a hardcoded string with another. Something like below:
'<ISP>':DSLink3.Table_column1:'</ISP> ':'<DI>':DSLink3.Table_column2:'</DI>
I have to pass this as one string per row in a table. But the problem is: if any of the above columns in a table(Table_column1 or Table_column2) is null...the whole string does not populate. I want to populate the string even if the column1 and column2 is null. Something like below:
<ISP></ISP><DI></DI> ---> I am tryign to achieve this in case of null values for columns Table_column1 and Table_column2.
Is there a way to concat the string with a null value.
I will really appreciate any advice and recommendation in this regards.
Thanks
Raj