-May-27-2025-10-14-42-1506-AM.png?width=150&height=38&name=IEGGroup-Logo_Black-filled%20(2)-May-27-2025-10-14-42-1506-AM.png){kind=logo}
T SQL Script: Trim All Leading or Trailing Spaces for Column Names in a Table
T SQL Script: Trim All Leading or Trailing Spaces for Column Names in a Table
-- Trim All Leading or Trailing Spaces for Column Names in a Table
UPDATE YourTable
SET ColumnName = LTRIM(RTRIM(ColumnName))
WHERE ColumnName LIKE ' %' OR ColumnName LIKE '% ';
UPDATE YourTable
SET ColumnName = LTRIM(RTRIM(ColumnName))
WHERE ColumnName LIKE ' %' OR ColumnName LIKE '% ';