Monthly Archives: January 2010

Don’t get caught by ANSI PADDING, VARCHAR, and trailing whitespace!

One thing to be aware of when you have VARCHAR columns and are using ANSI PADDING: trailing whitespace is trimmed and not counted in your equality ( = /  / LIKE) statements, so you might not get the results you are looking to be … Continue reading

Posted in MS SQL Server, T-SQL | Leave a comment