Filter function in sql.

Discussion in 'Questions (Windows Mobile)' started by belotrei, Jun 2, 2007.

  1. belotrei

    belotrei Member

    What is the syntax to filter sqlite database. Example: i just want to insert to the table, just the item starts with "a" from sql database.

    have tried like this:
    cmd.commandtext="select * FROM CDs WHERE Title LIKE 'A%'"

    Really confuse to place the ' or '' or maybe () sign..

    Thanks.

    Edit :
    Problem solved. The problem is in fact i'm using the order statement before the where.
     
    Last edited: Jun 2, 2007
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice