How to select only part of BLOB column

How can I select only 1kb from a BLOB field, in a SQLite Database?

I imagine it to be something like this

SELECT PART(`field_name`, startIndex, bytes) AS data FROM `table` ....

Is this possible?