How do you find ' % ' with the LIKE operator in SQL Server?

Ans : SELECT * FROM tableName WHERE columnName LIKE '%[%]%'

Any fool can write code that a computer can understand. Good programmers write code that humans can understand.