I'd like to see support for CASE statements in a Definition Query, particularly where the data is in an Enterprise Geodatabase (SDE) with a database engine that does support this sort of query.
For our notes, here's an example of your syntax working in SQL Server (the test has nothing to do with ArcGIS Pro):
https://dbfiddle.uk/shBxoaUj
How'd it turn out?
@Bud
Sub query didn't work but I just realised I didn't test it against non-versioned data so will give that a try tomorrow.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
