- 1
- 2
- 3
- 4
resultWhereClause += " AND (lower(concat(per.firstName,' ',per.lastName,' ',per.middleName)) like lower(#{utils.concat(\"%\", \"" + applicant + "\", \"%\")})";
resultWhereClause += " or lower(concat(per.lastName,' ',per.firstName,' ',per.middleName)) like lower(#{utils.concat(\"%\", \"" + applicant + "\", \"%\")})";
resultWhereClause += " or lower(concat(per.firstName,' ',per.middleName,' ',per.lastName)) like lower(#{utils.concat(\"%\", \"" + applicant + "\", \"%\")}))";
resultWhereClause += "))";