> There is no way to retrieve part of a > blob value in SQLite. > > From my understanding, most databases store > blob values separate from the rest of the row.
The common way to handle this in SQLite is to store the blob in a file and store the file name in the db. Regards