CONTAINING
Ïðåäèêàò CONTAINING àíàëîãè÷åí ïðåäèêàòó LIKE, çà èñêëþ÷åíèåì òîãî, ÷òî îí íå ÷óâñòâèòåëåí ê ðåãèñòðó áóêâ. Ðàçðåøåíî òàêæå èñïîëüçîâàòü êîíñòðóêöèþ NOT CONTAINING.
SELECT first_name, last_name
FROM employee
WHERE last_name CONTAINING "ne"
ïîëó÷èòü ñïèñîê ñîòðóäíèêîâ,
ôàìèëèè êîòîðûõ ñîäåðæàò áóêâû
“ne”, “Ne”, “NE”, “nE”
FIRST_NAME LAST_NAME
=============== ====================
Robert Nelson
Ann Bennet
Pierre Osborne
