title: How do you search for special characters in a substring SQL
body: <p>Hi basically i have a column for payment,  its either 0, a $[amt] or [amt]%, how do i search for substring that contains the %? right now i am just doing</p>
  
  <p><code>select * from table where not Payment like '$%' and not Payment =0</code></p>
  
  <p>to retrieve all the rows that contains a % in the substring</p>