Search code examples
sqlspecial-characterssccm

SQL - Exclude items from a table with a specific content

I'm running a query which works just fine when I'm working with normal chars but not with russian, polish etc chars. For instance, when I'm excluding a few items from the selection, this works:

and ARPDisplayName0 NOT LIKE '%Microsoft Office ScreenTip%

These lines instead are not being processed since I see them in the report:

and ARPDisplayName0 NOT LIKE '%Narzędzia sprawdzające pakietu Microsoft Office%'
and ARPDisplayName0 NOT LIKE '%Средства проверки правописания Microsoft Office%'

How can fix it? Thanks a lot :)

Solution

  • That's Unicode, so you need to put a N prefix before the strings, N stands for national character : 

    DECLARE @x NVARCHAR(max)
SET @x= N'unicode'