Ðàçðàáîòêà áàç äàííûõ â Delphi. 11 Óðîêîâ

       

 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



Ñîäåðæàíèå ðàçäåëà