Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

database searching

I am a beginner & designing a project in VB with access as backend.I am having problems in searching the database for records by using partial information.eg
there is a database for books.I have to search for books whose first letter is 's' or i have to search for a book even if i do not know the compelete name of the book.

How can this problem be solved?

Comments

  • BarkeeperBarkeeper Member Posts: 335
    : I am a beginner & designing a project in VB with access as backend.I am having problems in searching the database for records by using partial information.eg
    : there is a database for books.I have to search for books whose first letter is 's' or i have to search for a book even if i do not know the compelete name of the book.
    :
    : How can this problem be solved?
    :


    Lookup the SQL-Language, especially the "SELECT"-Statement with the "LIKE"-Operator.

    e.g. SELECT * FROM Books WHERE Title LIKE "Beg"
    should give you all Records with Title containing "Beg"

    e.g. SELECT * FROM Books WHERE Title="Beg*"
    should give you all Records with Title beginning with "Beg" (Note: the asteriks-character * can be % in some Databases.

    Zvoni
    ------------------------------------------
    Only stupidity of mankind and the universe
    are infinite, but i'm not sure concerning
    the universe. A. Einstein

Sign In or Register to comment.