Выборка пользователей у которых «не верный» код поиска.

1
2
3
4
5
6
7
8
9
select
PER_LASTNAME,
PER_FIRSTNAME,
PER_MIDDLENAME,
PER_SEARCHCODE,
PER_NAME,
PER_EMAIL
from ITSM_PERSONS
where UPPER(PER_LASTNAME || PER_FIRSTNAME || PER_MIDDLENAME) <> PER_SEARCHCODE;