Hello, I have two fields in one table and I need to combine them into a single field in a second table. The problem I have is that if the first field contains a null, the second field is not placed into the combined field in table2. I could update all nulls to values but this is not practical as they are needed elsewhere in the dbase. I am told that "If Null" could work but I have no clue about it. Please could one of you SQL heroes help me out?
Cheers folks
Rick Masters
Cheers folks
Rick Masters