Why does my full-text search return no results?

I have a simple one View:

http://i.imgur.com/fb0OKx0.png

Let me select the top 5 lines: (the view doesn't have it top 5- it's just for clarity here)

SELECT TOP 5 [CustomerId]
      ,[EngLastFirst]
      ,[EngFirstLast]
      ,[LocalLastFirst]
      ,[LocalFirstLast]
  FROM [WebERP].[dbo].[View_CustomersNames]

Result:

enter image description here

Let me create a full text index (right click on View):

enter image description here

OK so now we also have catalog:

Right-click on catalog- to see the properties:

enter image description here

All properties default:

enter image description here

Click rebuildon catalog:

enter image description here

Great

Run a simple query CONTAINS:

SELECT * FROM View_CustomersNames vcn 
        where CONTAINS( vcn.*, '"aerSwy*"') 

As you can see from the previous code, the record exists:

enter image description here

But returns no results

While likereturning results:

SELECT * FROM View_CustomersNames vcn 
        where  vcn.engLAstFirst LIKE '%aerSwy%'   

enter image description here

Question:

?

SELECT * FROM View_CustomersNames vcn 
        where CONTAINS( vcn.*, '"aerSwy*"')

NB - , - ( )

Edit

- . -

enter image description here

+4
2

-

:

enter image description here

CONTAINS:

enter image description here

+3

TOP 5 . , SQL. , , . SQL. http://www.w3schools.com/sql/sql_quickref.asp . sql, , . , , SQL.

-1

All Articles