I used to prepare an excel spreadsheet with find and replace for the following
comma , with space
blank spaces to 1 space only)
I am now taking this data directly into a table in sql so need to set up some routines that do the same thing to remove all commas, blank spaces, hidden characters from the various fields.
what would the syntax be?
could this be all done with one update statement?
john,smith john smith
becomes "john smith" in both cases