That doesn't look like the complete statement ... A leading N must be added before an opening quote when you are supplying a value for an NCHAR or NVARCHAR parameter, with a unicode character - for instance when calling sp_ExecuteSQL. EXEC sp_ExecuteSQL N'statement', N'parameter_list', N'value_list'