Filter function in sql.

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