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


    Edit :
    Problem solved. The problem is in fact i'm using the order statement before the where.
    Last edited: Jun 2, 2007