Page 1 of 1

Problem with Concatenate the string

Posted: Mon Nov 20, 2006 8:40 pm
by ramdev_srh
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

Posted: Mon Nov 20, 2006 9:21 pm
by ray.wurlod
Please post server questions in the server forum.

Use the NullToEmpty Transform

Code: Select all

NullToEmpty(FirstString):NullToEmpty(SecondString)