sql server - In a SELECT statement(MS SQL) how do you trim a string - Stack Overflow

For Example; SELECT TRIM(Names) FROM Customer ... I assume this is a one-off data scrubbing exercise. Once done, ensure you add database constraints to prevent bad data in the future e.g.

stackoverflow.com