• The estimated row counts are very different , are your statistics up to date ?

    Check this page in the section chapter "Increasing Full-Text Query Performance" for some good info

    http://technet.microsoft.com/en-us/library/cc721269.aspx

    Besides which, you have left yourself wide open to a sql-injection attack.



    Clear Sky SQL
    My Blog[/url]