Arcmap SQL wildcard

2654
1
04-28-2014 09:33 AM
DanielKim4
New Contributor
Hi there,

I would be appreciated if someone can help me with my SQL question.

I know that the wildcard for string (TEXT) is '%'.
Does anyone knows which wildcard I need to use for number field?

Your help would be appreciated.

Thank you.
Tags (2)
0 Kudos
1 Reply
RichardFairhurst
MVP Honored Contributor
Hi there,

I would be appreciated if someone can help me with my SQL question.

I know that the wildcard for string (TEXT) is '%'.
Does anyone knows which wildcard I need to use for number field?

Your help would be appreciated.

Thank you.


First of all why approach this with a wild card?  If you are trying to do this to isolate a digit position value use a modulus.  What is the database type (SDE or File geodatabase or shapefile) and what is the objective of the expression?

You would have to cast the number to text before you could use a wildcard, but I always get errors when I try to do that because the help is useless.  I spoke to the programmer about the SQL being wrong and he said he would have the help fixed to match a File Geodatabase, but it never happened.  You just have to randomly try every SLQ cast operator out there.  Still a modulus can do the same thing with a number.
0 Kudos