AnsweredAssumed Answered

Find hypen in text field

Question asked by MikeWile on Feb 22, 2018
Latest reply on Feb 22, 2018 by MikeWile

I have a table that contains 326,952 records. One field is a text field. In that field I am trying to omit any record that contains a hyphen but it's not working correctly. I've tried "-", =-, \-, but the hyphen still shows up in the found records. How do I omit records containing the hyphen? Even though the field is text, all but the hyphen are numbers usually in the form ####-# or #####-#.

Outcomes