Problem with Concatenate the string
Posted: Mon Nov 20, 2006 8:40 pm
Hi All,
Please let me know if I am trying to concatenate two columns from source and loading into target as single column. On source side, one column having value other one is maybe null. Usually if we add string with null we get null.
How can we overcome this problem?
we are using 7.1 server
Thanks & Regards
Deva
Please let me know if I am trying to concatenate two columns from source and loading into target as single column. On source side, one column having value other one is maybe null. Usually if we add string with null we get null.
How can we overcome this problem?
we are using 7.1 server
Thanks & Regards
Deva