I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window.
This was the most promising link that I've found, including the two links found there.
I haven't tried whether the syntax showed works against a file gdb but it doesn't work on SDE.
Anyone have luck using sql in ArcMap 10 against ArcSDE 10? Thanks.
This worked on sde when the field is a Double.
CAST(MP AS CHARACTER(12)) LIKE '7%'
It does work but '%5' doesn't work. Having the percent after works and before doesn't.