like for Arabic word

See more:

SQL-Server

hiii all
i have table in sql server 2008 database which contains arabic data anf now i create aprocedure to select id of an employee . but the i think that i have aproblem with the syntax because i tried it in english and works well.
So, Can any one helps me in that , please....

create proc [dbo].[usp_EmployeeAddress_Select] 
(
@EmployeeName nvarchar(50)
)
AS
DECLARE @query as nvarchar(100)
print N''+@PropertyValue
set @query = '
select dbo.tbl_Properties.Id
from dbo.tbl_Properties
where Name like N'''+cast(@EmployeeName as  nvarchar(50))+''''

Thanks