Hi,

I am writing a datapump application which populates an FB database
from another. Presently I am creating an SQL script (INSERT INTO ...)
to process all fields except the blobs. It works very fast.

For the BLOBS I am using parameterised queries in a Delphi app but
these take forever! :( I'd rather be able to do it via SQL.

Searching the web I came across a thread that said this sort of
function (StringToBLOB) was included in Firebird. Can anyone show me
the SQL for this please? I am using FB v1.5.2

TIA

Trev