Creating the SELECT Statement to Read from a Blob
From InterBase
Go Up to Reading Data from a Blob
Elicit a statement string from the user or create one that consists of the SQL query that will select rows containing the Blob data of interest. For example, the following creates a SQL query statement string that selects three columns from various rows in the PROJECT table:
char *str =
"SELECT PROJ_NAME, PROJ_DESC, PRODUCT FROM PROJECT WHERE \
PRODUCT IN ('software', 'hardware', 'other') ORDER BY PROJ_NAME";