SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE supplier (
  Name varchar(20),
  Surname varchar(20)
);


✓
insert into supplier values
('Rajini', 'Shah'),
('Dhiraj', 'Jain'),
('Filippo', 'Ken');
✓
CREATE TABLE Requestor (
  Fullname varchar(20),
  Age int,
  Town varchar(20)
);

✓
insert into Requestor values
('/-Vimal -/', 23, 'London'),
('Dhiraj--001/', 45, 'Paris'),
('Jay',0,'');
✓
SELECT T2."Fullname",T2."Town", T2."Age", T1."Surname"
FROM "Requestor" as T2
LEFT JOIN "Supplier" as T1 on T2."Fullname" LIKE '%' || T1."Name" || '%'
ORDER BY T2."Fullname" ;


Fullname
Town
Age
Surname


/-Vimal -/
London
23
null

Dhiraj--001/
Paris
45
Jain

Jay

0
null