none
search in a access database (query help) RRS feed

  • Question

  • Hi guys

    I was wondering how to make a search in a access database. My query looks like this:


    SELECT     ID,  Heading, Description, Fix,  Modified
    
    FROM         CoreData
    
    WHERE     (Heading = ?)
    
    

     

     

    Which work fine IF I type in the entire “heading” text, but I would like to use an asterisk.

     

    Eg.

    Heading field says “This is a test”

    If I search for “This” – I get 0 hits

    If I search for “This*” – I get 0 hits

     If I search for “This%” – I get 0 hits

    If I search for “This is a test” – I get 1 hit.

     

    That’s not much of a search function ;-)

     

    Any hints?

     

     

     

    Tuesday, July 21, 2009 7:39 AM

Answers

All replies