""C Fraser"" <Colin.Fraser@...> wrote in message
news:001801c1779f$0dc87170$8f01a8c0@COLINFRASER...

> I know it has been asked before... But I haven't been able to find the
> answer...
>
> Is it possible to insert strings into BLOBs (subtype 1) using SQL???

insert into table2(blobfield) values('string literal');

> Any stored procedures or user defined functions (Free UDF?) that can
> help?

Not necessary with FB. The feature has been available for a couple of public
betas, before the RC's. Anyway, freeudflib or fbudf will do the trick for IB
or if you have problems with the built-in feature.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing