Not searching unicode Urdu language keyword in SQL Tb while using N also

See more:

C#

SQL

search

i am passing where clause to store procedure execution. and searching Urdu language word

execute SPSearching @Mode ='Searching', @WhereClause= 'Hadith_Urdu Like N''%عبد%'''

but it doesnt provide me result whilc the serached word is present in database specified column

while my sp is

USE [SSDB2]
GO
/****** Object:  StoredProcedure [dbo].[SPSearching]    Script Date: 03/01/35 11:20:12 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date: 
-- Description:	
-- =============================================
ALTER PROCEDURE [dbo].[SPSearching] 
	-- Add the parameters for the stored procedure here
	@Mode varchar(50),
	@WhereClause  varchar(Max) = null
AS
if @Mode= 'ColumnNames'
BEGIN
	SELECT column_name FROM information_schema.columns WHERE table_name = 'Hadiths_old'
END

 
if @Mode= 'Searching'
BEGIN
declare @SQL VARCHAR(MAX)
 
SET @SQL='Select [Hadith_Text]
      ,[Hadith_Urdu]
      ,[Hadith_English]
      ,[Chapter_English_Name]
      ,[Chapter_Urdu_Name]
      ,[Baab_English_Name]
      ,[Baab_Urdu_Name]
      ,[Baab_Id]
      ,[Hadith_Book_Number]
	  From Hadiths_old
	  Where '
 
IF @WhereClause<>''
	SET @SQL=@SQL+'  '+ @WhereClause + ' order by ID'
 
EXEC(@SQL)
 
END

if i try to search english word then it is searching very fine.

execute SPSearching @Mode ='Searching', @WhereClause= 'Hadith_English Like N''%allah%'''

but i dont know it not working with unicode i have prefixed my searched word with N but not working