Page 1 of 1

Data Cleanup

Posted: Wed Oct 19, 2005 9:31 pm
by jwalsh
Hi,

Trying to clean up some data from a data entry clerk, is there a way to fix the following 2 problems using SQL only?

1) Remove trailing whitespace from all entries?
2) Remove Hyphens (-) from all entries?

Josh

Posted: Wed Oct 19, 2005 9:43 pm
by feyd

Posted: Wed Oct 19, 2005 9:59 pm
by jwalsh
Thanks.

FYI.. RTRIM() (duh, just didn't know mysql had that function) and REPLACE() (again, didn't know mysql had it)