AnsweredAssumed Answered

SQL LIKE statement with DataDrivenPages

Question asked by DemersM on Nov 14, 2012
Latest reply on Nov 15, 2012 by msayler-w

I'm trying to include a SQL LIKE statement in a python script but I cant find any documentation about this kind of query. Is it possible to do a LIKE query inside arcpy?

My problem is the following: I want to display features from a city layer when the ID of the Current DataDrivenPage is found in the column PAGE_ID of this layer. Some cities will be displayed in many pages so we have separeted the ID with a coma.

I would like to do a query like this one with arcpy:

SELECT * FROM CITY WHERE [PAGE_ID] LIKE %[current_dataDrivenPage_id]%

Thank you for your support!
Maxime Demers