--drop table fts_studenci
create table fts_Studenci
(
    ID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
    imie varchar(25),
    nazwisko varchar(25),
    pesel varchar(25),
    email varchar(25)

)

insert into fts_Studenci(imie, nazwisko, pesel, email)
values
    ('Maciej', 'Brylka',  '94071506990', 'mbrylka@gmail.com'),
    ('Czarek', 'Calus',   '96012242312', 'pionekplay@gmail.com'),
    ('Filip', 'Wojcik',   '95021342314', 'fwojcik@wp.pl'),
    ('Mariusz','Cieslak', '95023123412', 'mcieslak@onet.pl'),
    ('Konrad', 'Adamczyk','94123141292', 'kadamczyk@gmail.com'),
    ('Adam', 'Nowak',     '96122312359', 'anowak@wp.pl'),
    ('Rafał', 'Gliński',  '94071012388', 'rglinski@onet.pl')


create fulltext catalog FTS_Catalog
with accent_sensitivity = off

exec sp_help fts_studenci
--PK__fts_Stud__3214EC2784324A49

create fulltext index on fts_Studenci
(imie, nazwisko, pesel, email)
key index PK__fts_Stud__3214EC2784324A49
on FTS_Catalog
with stoplist = system



select * from fts_studenci
where contains(email,'gmail or wp')