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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion