Post reply

TRANSFORM VARIABLE - ADD OPERATOR OR

  • May 2, 2015 at 3:55 pm

    #398401

    I have a text box on a web application that allows the user to type what words they want to look. In the first version of the web application the user wrote the words he wanted and was wanted on the table by CONTAINS various words with the OR operator . What I wanted now was to allow the user to write several words, but with a particularity . The words that were inside '' was like a word.

    I wish my transform variable, so that adding the OR operator, and the words within the quotes are not to put the OR.

    ALTER PROCEDURE

    @product = ' 'ORANGE LEMON' BANANA APPLE 'PEACH PEAR' '

    AS

    -- I WANT TRANSFORM THE WORDS

    @product = 'ORANGE LEMON' OR BANANA OR APPLE 'PEACH PEAR'

    What I meant was that even using the full-text functionality. I'm using CONTAINS . But before the CONTAISN was :

    SELECT Description FROM Production.ProductDescription WHERE CONTAINS ( Description, PRODUCT )

    Since PRODUCT and was researched by words such as ORANGE LEMON OR OR OR BANANA APPLE OR PEAR OR PEACH .

    What is wanted now the words that come from the WEB application within '' stay as if it were the AND operator then was :

    Product = '' ORANGE LEMON ' BANANA APPLE ' PEACH PEAR ''

    PRODUCT = ' ( ORANGE AND LEMON ) OR BANANA OR APPLE OR ( PEACH AND PEAR) '

  • May 3, 2015 at 4:07 am

    #1795219

    you need to parse search string and compose FTS query sting, no easy "replacements" here.

    C# example[/url]

  • May 3, 2015 at 5:40 am

    #1795229

    You might be better off if you at least require the users to separate the words with commas. Then you can use a tally table to split the strings easily. Check out this article [/url]for an example.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 3, 2015 at 5:43 am

    #1795232

    Please don't post any more answers to this thread. A more complete conversation is taking place here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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