So yes, this post is solely for my benefit.
Hopefully it will help somebody else too.
Search For Rows With Special Characters in SQL Server
While troubleshooting a programming problem today I noticed that you can't use a LIKE search for string columns containing special characters like % or _ without using a special syntax. Figuring out the problem took only a few minutes, but remembering syntax is always easier if you write about it.
