I am working with an attribute table that uses single, double, and triple asterisks to designate Wild and Scenic Rivers.I would like to Select by Attribute to filter the records that contain asterisks--I intend to export these records to a separate shapefile just for Wild and Scenic Rivers. I tried using the LIKE expression as follows, to no avail:

Faulty Code

  • 3
    A good way to say thanks is to mark answers as accepted. – reevesii Jun 20 '17 at 18:23
  • Oops; I'm new here; I was actually looking for a way to do that and I just realized that I need to hit the checkmark! – Payman Alemi Jul 11 '17 at 0:57

Your query is only looking for text with an asterisk with some text after the asterisk. Try using "ID LIKE'%*%'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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