How to search for "%" in sql table-column

Question

I have a table with a column "Remarks"...How to search "%" in this column?

Answer 1

Like this

where Remarks like'%[%]%'

you need to put brackets around it, more info here LIKE (Transact-SQL)

Answer 2

SELECT *
    FROM YourTable
    WHERE CHARINDEX('%', Remarks) > 0