ArcGIS—IQueryFilter查询区分大小写 (转)

QueryFilter pQueryFilter = new QueryFilter();

String whereclause = "UPPER(/"NAME/") like UPPER('%jack%')";

pQueryFilter.setWhereClause(whereclause);

在条件语句上的前后都加上UPPER转换,这样就不区分大小写了。

以下有VB的IQueryFilter.WhereClause Property文档:

http://edndoc.esri.com/arcobjects/9.2/ComponentHelp/esrigeodatabase/IQueryFilter_WhereClause.htm

from:http://blog.csdn.net/liang_zhiqiang/article/details/4236575

原文地址:https://www.cnblogs.com/yuxuetaoxp/p/2751045.html