Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java =================================================================== diff -u -r35257 -r35263 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 35257) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 35263) @@ -2782,7 +2782,7 @@ int index = searchString.indexOf("["); searchString = searchString.substring(0, index) + "\\" + searchString.substring(index, searchString.length()); sql += " and (spelling like '%" + searchString + "%' "+ " escape '\\' " +" or wbCode like '%" - + searchString + "%' "+ " escape '\\' " +" or externalCode like '" + searchString + + searchString + "%' "+ " escape '\\' " +" or externalCode like '%" + searchString + "%' "+ " escape '\\' " +" or po.name like '%" + searchString + "%' "+ " escape '\\' " +")"; }else{ sql += " and (spelling like '%" + searchString + "%' or wbCode like '%"