Remove white space from concatenated string fields in MySQL

Question

I have 3 fields I am concatenating and it's working just fine in my query, but I cannot resolve how to remove the whitespace from the merged data in the concat field.

TRIM(CONCAT(c.data1,c.data2)) AS concat_done

Result:

concat_done
33 0250S 0450E 028NW

Answer 1

instead of

TRIM(CONCAT(c.data1,c.data2)) AS concat_done

try

REPLACE(CONCAT(c.data1,c.data2), ' ', '') AS concat_done

Answer 2

add a REPLACE call:

REPLACE(TRIM(etc...), ' ', '')
                       ^--one space
                            ^-- no spaces