Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/action/TousseDefinitionAction.java =================================================================== diff -u -r27097 -r27114 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/action/TousseDefinitionAction.java (.../TousseDefinitionAction.java) (revision 27097) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/action/TousseDefinitionAction.java (.../TousseDefinitionAction.java) (revision 27114) @@ -1389,7 +1389,7 @@ } if (StringUtils.isNotBlank(spell)) { spell = java.net.URLDecoder.decode(spell, "UTF-8").trim(); - condition += " and (name like '%"+ spell +"%' or spelling like '%"+ spell +"%' or wbCode like '%"+ spell +"%')"; + condition += " and (name like '%"+ spell +"%' or upper(spelling) like upper('%"+ spell +"%') or upper(wbCode) like upper('%"+ spell +"%'))"; } JSONArray jsonArray = new JSONArray(); int totalCount = objectDao.countBySql("select count(0) from " + TousseDefinition.class.getSimpleName() + condition);