reverse like search in SQL code example

Example 1: sqlserver: reverse like search

select * from table where '+92 343 9879098' like '%' || number || '%';

Select * from country
where CHARINDEX(country.Name, 'Republic of Macedonia') > 0