Retriving Arabic Value from sqlserver using stored procedure not giving any values

See more:

SQL-Server

SQL-Server-2008

Hai,
 i am trying to get the Arabic matched values from the DataBase using  stored procedure in sqlserver 2008..
But it didn't returns the matched values.. why..

My Table Design is like

CREATE TABLE #test1
(
col1 nVARCHAR(100)  ,
col2 nVARCHAR(100)  ,
col3 NVARCHAR(100)
)

INSERT INTO #test1 VALUES(N'لا أتكلم العربية',N'لا أتكلم العربية',N'لا أتكلم العربية')

INSERT INTO #test1 VALUES( ' fdfdf', 'dfdfdf', '45dfdf')

SELECT * FROM #test1

it showing the result like below well...

col1	col2	col3
لا أتكلم العربية	لا أتكلم العربية	لا أتكلم العربية
 fdfdf	dfdfdf	45dfdf

The given query giving the exact results while i am searching for the Arabic words..

declare @ColVal nvarchar(100)
 set @ColVal=   N'لا أتكلم العربية'
print @ColVal
select * from #test1 where col2 like @ColVal

But when i trying to retrieve the same data using the Stored Procedure it doesn't showing the Matched records any more even they exist in table..

My stored Procedure is

create proc Sp_TestArabic1 (@colValue nvarchar(100))
as
declare @ColVal nvarchar(100)
begin
set @ColVal=  'N'+@colValue
print @ColVal
select * from #test1 where col2 like @ColVal
end

exec Sp_TestArabic1 'لا أتكلم العربية'

Doesn't give any results , I tried with debugging the Stored porcedure, all the columns passes the values well but it doesn't returns the Correct results..


please provide exact solution to search the Arabic words based on the Condition...

Thank you..