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...

  • 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.