How to Select by attribute that "contains" a particular number

[PascalineWallemacq]

Hello,
How is it possible to make a "select by attribute" for numbers but numbers contained in the attribute?
I would like to select all the attributes that contains the number '16777'. Sometimes it's only '16777' so very easy, but sometimes it's '16857 | 18754 | 16777'
How can I do to make a select attributes that "contains" the number '16777'?

Thanks a lot.

[TimWitt · Accepted solution]

Pascaline,

Lets say your attribute is NUMBER, just use the following code in your "Select By Attribute":

NUMBER LIKE '%16777%'

With this there can be anything infront or after 16777, the % is your wildcard.

Hope this helps!

Tim

[PascalineWallemacq]

Thanks a lot Tim, now it works very well!!

[TimWitt]

No problem! Don't forget to mark the answer, by clicking the grey check mark on the right 🙂