[AltPartNo01] + ' ' + [AltPartNo02] + ' ' + [AltPartNo03] as test
Above statement will show test column has value if all altpartno01, 02, 03 has value. If any one of those don't have value, test shows nothing. Why and how to fix it. My goal is to make them together as one column name test.
regardless what it is inside of the column.