quote:

---

Originally posted by webfred

Do you want to find "United States of America" with this "unitedstatesofamerica" or not?

---

Too old to Rock'n'Roll too young to die.

---

-- sample table
declare @Sample table (countrycode varchar(2), countryalias varchar(255))

-- sample data
insert @Sample
select 'NL', 'nederland' union all
select 'NL', 'netherlands' union all
select 'NL', 'paysbas' union all
select 'US', 'unitedstatesofamerica' union all
select 'US', 'america'

-- show sample data
select * from @Sample

--Also I have a string e.g. "kevin lives in the United States of America".

-- solution
select * from @Sample
where replace('kevin lives in the United States of America',' ','') like '%'+countryalias+'%'

quote:

---

Originally posted by webfred

This?

-- sample table
declare @Sample table (countrycode varchar(2), countryalias varchar(255))

-- sample data
insert @Sample
select 'NL', 'nederland' union all
select 'NL', 'netherlands' union all
select 'NL', 'paysbas' union all
select 'US', 'unitedstatesofamerica' union all
select 'US', 'america'

-- show sample data
select * from @Sample



--Also I have a string e.g. "kevin lives in the United States of America".

-- solution
select * from @Sample
where replace('kevin lives in the United States of America',' ','') like '%'+countryalias+'%'

---

Too old to Rock'n'Roll too young to die.

---