MSSQL trailing whitespaces in string values

November 28, 2024

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ef/known-issues-in-sqlclient-for-entity-framework#trailing-spaces-in-string-functions
SQL Server ignores trailing whitespaces in string values, this can lead to issues downstream

-- check which values have trailing whitespaces
SELECT [ticker] FROM [DB].[SCHEMA].[TABE] WHERE [ticker] LIKE '% '
 
-- update values to remove trailing whitespaces
UPDATE [DB].[SCHEMA].[TABE] 
SET [ticker] = RTRIM([ticker])
WHERE [ticker] LIKE '% ';