In this post, I am sharing a TSQL script to remove the trailing characters from the Number value in SQL Server. Before a few days ago, I did a data migration from old CSV files to SQL Server table and found few number values with the junk of trailing characters like km, kg. Those trailing … Continue reading SQL Server: Script to Remove Trailing Character from Number Column