Arcmap SQL wildcard

DanielKim4 — Mon, 28 Apr 2014 16:33:53 GMT

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.

Re: Arcmap SQL wildcard

RichardFairhurst — Mon, 28 Apr 2014 17:59:54 GMT

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.

topic Arcmap SQL wildcard in ArcGIS Enterprise Portal Questions

Arcmap SQL wildcard

Re: Arcmap SQL wildcard