Column A (1, Michigan Street, Michigan),
Column B (Michigan Street) and
Column C (Yes, No).
I want to use Field Calculator to update
Column C in a way that it return NO if
Column A contains the same street name as
Column B. However, it does not work. What I tried:
Case when "Column A" LIKE '%"Column B"%' then 'No' else 'Yes' end
So I try to go longer route by selecting features in
Column A if it has exact words in
"Column A" LIKE '%Column B%'
but it doesn't work either. Any idea on what expression to use as I don't want to write every code differently according to