--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', '[email protected]'),
    ('Czarek', 'Calus',   '96012242312', '[email protected]'),
    ('Filip', 'Wojcik',   '95021342314', '[email protected]'),
    ('Mariusz','Cieslak', '95023123412', '[email protected]'),
    ('Konrad', 'Adamczyk','94123141292', '[email protected]'),
    ('Adam', 'Nowak',     '96122312359', '[email protected]'),
    ('Rafał', 'Gliński',  '94071012388', '[email protected]')


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')