• I am getting same problem but its reverse

    I am getting my record if I am searching with Contains(group_name , '"Region 3 North"') but its not return my data if I am searching with Contains(group_name , '"Region 3 North*"')

    I have already created stopList and assign to my index like

    CREATE FULLTEXT INDEX ON [dbo].[tbl_temp]

    (

    City

    Language 1033,

    State

    Language 1033,

    Country

    Language 1033,

    Zip

    Language 1033,

    Group_Name

    Language 1033

    )

    KEY INDEX [ClusteredIndex-20140625-154702]

    WITH STOPLIST = [stoplistName]--SYSTEM

    GO

    Thanks in advance.