This question already has an answer here:

I have a large data set of points which has the field 'Name'.

Some of the points have an attribute such as 'Slope >40%' or 'Grade 10-30%' for example.

I would like to use Select By Attributes and the LIKE operator to select all points which have a % within the attribute.

I've tried different combinations such as:


But no luck on trying several combinations...

marked as duplicate by PolyGeo arcgis-desktop Jan 18 '17 at 23:35

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    Please edit the question to specify the data format involved (if enterprise geodatabase, specify the RDBMS) – Vince Jan 18 '17 at 22:52

Name LIKE '%$%%' ESCAPE '$'

whatever character comes after the escape character will pick up a % or _ as jsut a regular character instead of special

Not the answer you're looking for? Browse other questions tagged or ask your own question.