Filter function in sql.

[belotrei]

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.