DECLARE @txt_search VARCHAR(400) = N'"Привет*" AND "Иванов*"'
			SELECT
				 TextColumn
			FROM 
				TextTable
			WHERE 						
				 CONTAINS (TextColumn, @txt_search )

DECLARE @txt_search VARCHAR(400) = N'"Привет*" AND "Иван*"'

			DECLARE @txt_search VARCHAR(400) = N'"Привет*" AND "Иван*"'
			SELECT
				 *
			FROM 
				TextTable INNER JOIN
				CONTAINSTABLE(TextTable , TextColumn, @txt_search) AS KEY_TBL
				ON org_id = KEY_TBL.[KEY]
			ORDER BY RANK

			DECLARE @txt_search VARCHAR(400) = N'"Привет*" AND "Иван*"'
			DECLARE @txt_search2 VARCHAR(400) = N'Привет Иван'		
			SELECT
				 *
			FROM 
				Orgs 
				INNER JOIN				
					CONTAINSTABLE(Orgs, org_name, @txt_search) AS KEY_TBL ON org_id = KEY_TBL.[KEY]				
				LEFT JOIN
					FREETEXTTABLE(Orgs, org_name, @txt_search2) AS KEY_TBL2 ON org_id = KEY_TBL2.[KEY]		
			ORDER BY KEY_TBL2.RANK DESC

USE AdventureWorks2012;
GO
SELECT Name
FROM Production.Product
WHERE CONTAINS(Name, ' "Chain*" ');
GO