Hi guys
I have database hr has table Employee this table has field EmployeeName
EmployeeName nvarchar(50)
when i write in query analyzer :
select ^ from Employee where EmployeeName='????'
not give me any result
but when i write
select * from Employee where EmployeeName=N'????'
it give me result
meaning it support arabic
but i have stored procedure not accept arabic and i dont know how to handel it to accept search by EmployeeName
CREATE Procedure sp_EmployeeSelect
@EmployeeName nvarchar(50)
AS
Declare @SQLQuery as nvarchar(2000)
SET @SQLQuery ='SELECT * from Employee Where (1=1)'
If @EmployeeName <>''
Set @SQLQuery = @SQLQuery + ' AND (EmployeeName LIKE ''%'+@EmployeeName +'%'') '
Exec (@SQLQuery)
what is the proplem in this stored procedure and how to solve it
please help me