SQL Server: IN ('asd') does not work when NTEXT column

A list INis simply an abbreviation for OR conditions. Offer LIKEworks with NTEXTand fields TEXT. So you can combine these two ideas to do this:

WHERE (
       someNtext LIKE N'asd'
OR     someNtext LIKE N'asd1'
      )

, @marc_s , NVARCHAR(MAX) , ( TEXT, NTEXT IMAGE SQL Server 2005). , :

WHERE CONVERT(NVARCHAR(MAX), someNtext) IN (N'asd', N'asd1')

, , , LIKE OR.

: NVARCHAR NTEXT/NVARCHAR/NCHAR/XML NCHAR "N". , , .

/ /Unicode/ SQL Server, , : https://Collations.Info/