SQL-like expression can't find half space character (Zero-Width-Non-Joiner (ZWNJ))
Select *  from
     (select token = 'aaa‏‏sss') as dd
  where token like '%‏‏%'

aaa‏‏sss

null

select PATINDEX('%‏‏%','aaa‏‏sss' collate  Arabic_CI_AS)

select PATINDEX('%‏‏%','aaa‏‏sss' collate  SQL_Latin1_General_CP1_CI_AS)

Select *  from
     (select token = 'aaa‏‏sss') as dd
  where token like N'%‏‏%'