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