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
instead of
TRIM(CONCAT(c.data1,c.data2)) AS concat_done
try
REPLACE(CONCAT(c.data1,c.data2), ' ', '') AS concat_done
add a REPLACE call:
REPLACE(TRIM(etc...), ' ', '')
^--one space
^-- no spaces
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With