Antonio Olmedo Commented 1 Years ago through
Blogs
There is a way SQL Server can distinguish those trailing blanks, with the functions RTRIM and LTRIM.
So, after altering the column to varchar, you just need to update the values on it:
`UPDATE CityMaster SET CityName = LTRIM(RTRIM(CityName))`
...