Special Char % in SQL Query
I try excuting a SQL Query like this
SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...
How can I take % to query, with
it'll get all record in table.
Someone give me an idea. Thanks so much!