sqlserver: reverse like search code example

Example 1: sqlserver: reverse like search

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

Example 2: sqlserver: reverse like search

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