Lookup entire column data in another column in sql server

ALTER FUNCTION [dbo].[SearchCompany](@Article nvarchar(MAX)) 
RETURNS INT
AS 
BEGIN	
    DECLARE @Found INT,  @Company nvarchar(MAX), @last_cell nvarchar(MAX), @RowNum INT, @CustId INT    
	SELECT @CustId = MAX(Id) FROM NetCrawlerDemo.dbo.Co_Industry_Mast --start with the highest ID
	SELECT @RowNum = Count(*) FROM NetCrawlerDemo.dbo.Co_Industry_Mast --get total number of records	
	While @RowNum > 0 --loop until no more records
		BEGIN 			
		    SELECT @Company = Searchable_company_Name FROM NetCrawlerDemo.dbo.Co_Industry_Mast WHERE Id = @CustId  --get other info FROM that row		    
			SET @Found = CHARINDEX(@Company, @Article) --find the company in Article Details
				WHILE @Found > 0   --loop until no more records
				BEGIN
					SET @Found = CHARINDEX(@Company, @Article)--find the company in Article Details
					IF @Found > 0 --condition for 1 or 0
						RETURN 1
					ELSE
						RETURN 0										
				END
			SELECT TOP 1 @CustId= Id FROM NetCrawlerDemo.dbo.Co_Industry_Mast WHERE Id < @CustID ORDER BY Id DESC	--get the next one		
			SET @RowNum = @RowNum - 1 --decrease count	
	END    
	RETURN @Found 
END

ALTER PROCEDURE [dbo].[ExactSearch]
AS
BEGIN
	SET NOCOUNT ON
	DECLARE @Command NVARCHAR(MAX)	
		
	SET @command = '
			UPDATE [NetCrawlerDemo].[dbo].[DA_TrackerInfo_SGA_ExactSearch]
			SET [CompanySearch] = [dbo].[SearchCompany] ([DA_ArticleDetails])'
			BEGIN TRY
				EXEC(@Command)
				PRINT
					N'CompanySearch Column updated...Successfully.'
			END TRY
			BEGIN CATCH
				PRINT 'CompanySearch Column Error'
			    SELECT 
				ERROR_NUMBER() AS ErrorNumber
				,ERROR_MESSAGE() AS ErrorMessage;
			END CATCH	
				
END