Chance1234
IS-IT--Management
Ever find yourself in one of those situations where you ask do you really want to do that ? are you sure ? ok then dont blame me.
I have a table with 8 fields, first one is CustID, the next seven fields are called Address Line 1, Address Line 2, etc etc
what I need to do Is combine all those fields into one, but not all the fields are populated , some records are fully complete others ahve bits and pieces missing from other fields
now they want each Line seperated by a comma,
without writing a million and one If statements anyone know a better way of doing this ?
I have a table with 8 fields, first one is CustID, the next seven fields are called Address Line 1, Address Line 2, etc etc
what I need to do Is combine all those fields into one, but not all the fields are populated , some records are fully complete others ahve bits and pieces missing from other fields
now they want each Line seperated by a comma,
without writing a million and one If statements anyone know a better way of doing this ?