Problem in Unicode Comparsion

Your Insert and Select Query both must have N

CREATE TABLE t (col1 nvarchar (30));
INSERT INTO t VALUES (N'?????');
SELECT *
FROM t
WHERE col1 LIKE N'%??%';

Check this is correct answer if it helped

Hello Sukesh,

Thanks for u r Reply, i am writing query as u told , but still does't make any difference :

here is Example :

select * from [User] where DisplayName like N'%?%'

Sukesh Marla14y ago

You might be doing like this

SELECT TOP 1000 [Book]

FROM [BookIssue]

where Book='?????'

Try this one

SELECT TOP 1000 [Book]

FROM [BookIssue]

where Book=N'?????'

Check this is correct answer if it helped.