Is it possible to search a sequence of bytes within a BLOB? Lets say i have a BLOB that contains 4 text fields 32 characters long ie firstname, lastname, street, city.
Can I form a query that looks something like: SELECT Bytes33to64 FROM MyTable WHERE Bytes33to64 LIKE 'Jones' instead of SELECT lastname FROM MyTable WHERE lastname LIKE 'Jones' Is there anyway to do this? This would allow me to store a single UDT as a BLOB and treat it like a series of columns in a table. --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users