I have SSN's in a field that have a ascii character 160 in front of them which is a non-breaking space. I tried teh Ltrim and replace but it seems not to have a effect how can I get ride of this space.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.