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

7815
3
Jump to solution
12-09-2013 12:10 AM
PascalineWallemacq
New Contributor II

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.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
TimWitt
Frequent Contributor
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

View solution in original post

3 Replies
TimWitt
Frequent Contributor
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
New Contributor II
Thanks a lot Tim, now it works very well!!
0 Kudos
TimWitt
Frequent Contributor
No problem! Don't forget to mark the answer, by clicking the grey check mark on the right :)
0 Kudos