B belotrei Member Jun 2, 2007 #1 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
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.