[sqlite] matching only part of a string

Hi, My table contains a text field called Name. Let the data be Name --- Abc abcd AB cab def I want to selcct all the rows which contains the term ab (not case sensitive). How can I do this? Thanks in advance, Lloyd - This email was sent using

Re: [sqlite] sqlite backup from the program.

Whether your database creation error solved? what was the problem? - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, November 03, 2006 2:18 PM Subject: [sqlite] sqlite backup from the program. Hi All, How to take a backup of the

Re: [sqlite] sqlite backup from the program.

SQLite database is stored as a normal file in the disk. Why dont you use Operating System calls to back up the file? - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, November 03, 2006 2:18 PM Subject: [sqlite] sqlite backup from the program.