You will need to create Full Text Search on PDF file.
I added the code below, hope you will understand.
At step 4 , you need to run the quesry with you "search text".
Step 1: Create Full Text Catalog
EXEC sp_fulltext_database 'enable'
GO
IF NOT EXISTS ( SELECT * FROM sys. fulltext_catalogs
WHERE name = 'Ducuments_Catalog' )
BEGIN
EXEC sp_fulltext_catalog 'Ducuments_Catalog' , 'create' ;
END
GO
Step 2: Create a Table
CREATE TABLE [dbo].[T_Document](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[FileName] [varchar](100) NULL,
[FileType] [varchar](50) NULL,
[Content] [varbinary](max) NULL,
CONSTRAINT [PK_T_Document] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Step 3: Create Full Text Index on Table Columns
CREATE FULLTEXT INDEX ON [dbo].[T_Document]
( Content Type Column FileType Language 1033,
[FileName] language 1033
)
KEY INDEX PK_T_Document
ON Ducuments_Catalog WITH CHANGE_TRACKING AUTO;
GO
Step 4: Run the Query
SELECT * FROM T_Document WHERE FREETEXT (Content,'Borrower Name')
SELECT * FROM T_Document WHERE CONTAINS (Content,'"Borrower Name"')