Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1

    Unanswered: Carry out a search using keywords

    I am currently working on a new project, where as a business we have to quote on baskets of products supplied to us by a customer. The issue I have is the UOM (Unit of Measure) for pricing purpose’s, I have a table containing Key words, eg, “Mtr” “Ft” “Ml” “Grm” etc…..

    What I want to do is this using the table containing the key words, scan the Part description field, held within another table, and flag that record, for further analysis.

    E.g. 110038X10FT:REN – in this example “FT” has been found

    How do I go about this

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    FROM   parts
     INNER
      JOIN keywords
        ON parts.description LIKE '% + keywords.word + '%'
    You may need some parenthesis on this, and maybe the ampersand (&) instead of plus (+) but the idea is there methinks.
    George
    Home | Blog

  3. #3
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1
    Thanks georgev,

    I'll give it a whirl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •