<div>
if you mean blanks, use the RTRim and LTrim function:<br />
UPDATE YourTable<br />
SET YourCol = LTrim(RTrim(YourTable))<br />
<br />
If the column is CHAR(100), there will always remain the trailing spaces, as SQL Server keeps them. This can only be changed by changing the data type from CHAR to VARCHAR.<br />
<br />
if you want to remove zeroes (0), i will post other script...
</div>


if you mean blanks, use the RTRim and LTrim function:
UPDATE YourTable
SET YourCol = LTrim(RTrim(YourTable))

If the column is CHAR(100), there will always remain the trailing spaces, as SQL Server keeps them. This can only be changed by changing the data type from CHAR to VARCHAR.

if you want to remove zeroes (0), i will post other script...

<div>
could you post the script to remove zeroes ...
</div>


could you post the script to remove zeroes ...

<div>
<div class="content wysiwyg-content">
How do I remove leading and trailing zeroes in a column (string/char(100))?
</div>
</div>


How do I remove leading and trailing zeroes in a column (string/char(100))?

Remove leading/trailing zeroes

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.