We'd like to remove the CR/LF from a single field called "ADDITIONAL_INFO". The tricky part is, is that there may be one or more CR/LF within the data. After the CR/LF(s) are removed we need a space between the data. There may be CR/LF at the beginning and at the end of the field.
For example, "JOHN DOE <cr/lf> <cr/lf> AND JANE DOE <cr/lf>" would become "JOHN DOE AND JANE DOE" as the field.
PS: We are using SQL Server to connect to DB2 (if that matters).