How to make a morphological search?

Question

Good afternoon.

I have a request:

SELECT * FROM Firm WHERE name LIKE '%' 

Please tell me how to use morphological search with this query in MsSQL 2008?

Answer 1

 Declare @find NVarchar(20)='test' SELECT * FROM Firm WHERE name LIKE '%' +@find +'%' OR phone LIKE '%' +@find +'%' 

Answer 2

Just run below Query

 SELECT * FROM Firm WHERE name LIKE N'%' -- ^ Magical Code 

SQL Fiddle