Little SQL Server Tricks: Escape in LIKE Queries
If you search for a value with an in the name, you learn something new about SQL Server, but end up with a result that does not match your expectation: sql SELECT FROM [dbo].[DatabaseLog] WHERE Object LIKE ’% %’ If we run this query, we do not get back everything with an in it. Instead, we get back...