Azure SQL is not returning the result

Question

I have a simple query like below

select * from regulation where description = 'Regulation (EU) 2016'

select * from regulation where description like '%Regulation (EU)%'

select * from regulation where description like '%Regulation (E%'

None of the above query is returning the result.

However, when I do

    select * from regulation where description like '%Regulation%'

The result is getting returned as, Regulation (EU) 2016

I checked if there is any space or any other char, but nothing is present. The description type in table is (nvarchar(max),null)

It's quite strange, I'm confused and never seen such problem. Did anyone faced similar problem ? Or, am I doing something wrong? Or, is it something Azure SQL setting or cache related and I need to ask DBA for re-indexing?