=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patientattributevalue/hibernate/HibernatePatientAttributeValueStore.java'
--- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patientattributevalue/hibernate/HibernatePatientAttributeValueStore.java	2011-08-03 07:44:26 +0000
+++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patientattributevalue/hibernate/HibernatePatientAttributeValueStore.java	2011-09-21 08:33:55 +0000
@@ -235,8 +235,8 @@
             }
 
             hql += " ( SELECT p" + index + " FROM Patient as p" + index + " JOIN p" + index
-                + ".identifiers as identifier" + index + " " + "WHERE  lower(identifier" + index
-                + ".identifier) LIKE lower('%" + searchText + "%') " + "OR (lower(p" + index
+                + ".identifiers as identifier" + index + " " + "WHERE lower(identifier" + index
+                + ".identifier)=lower(" + searchText + ") " + "OR (lower(p" + index
                 + ".firstName) LIKE lower('%" + firstName + "%') " + "AND lower(p" + index + ".middleName) = lower('"
                 + middleName + "') " + "AND lower(p" + index + ".lastName) LIKE lower('%" + lastName + "%')) ";