Post reply

Query with CONTAINS or FREETEXT with like??

  • June 30, 2008 at 9:18 pm

    #189879

    Hi,

    There's a way to make a query with FREETEXT sentence plus an like command??

    Example:

    select * from objects.objects where freetext (Name, 'JONATHAN');

    Desire:

    select * from objects.objects where freetext (Name, 'JON%');

    But this command do not show result....

    Can you help me?

    Thanks....

  • July 2, 2008 at 6:40 am

    #837171

    Try looking up CONTAINS in BOL. FREETEXT may not always recognize a shorter version of a name, and I don't think it works with wildcards.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • July 2, 2008 at 9:01 am

    #837292

    See BOL for details, syntax, and examples.

    1. Use CONTAINS vs. FREETEXT as FREETEXT has a number of limitations.

    2. The CONTAINS wildcard character is an asterisk (*).

    3. Note the limitations of where the wildcard character can be used:

    3.1 Only at the end

    3.2 If entered in a phrase search "word1 word2 word3..." then it can only appear on the last term and will wildcard all of the terms.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply