moving text BLOBS?
Posted in 1997
I need to extract existing text BLOB data from one table and insert the BLOB into a different table using only ISQL ( not 4GL, ESQL/C, etc. ) for a bunch of records! Has anyone developed a simple technique that works around the quotes, commas, etc. that occur in the free form text and that seem to confuse any attempt at writing an acceptable SQL insert statement? Thanks, Jim -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Jim Kistler - kistler@an.hp.com # Some see issues and ask, "Why? Hewlett-Packard Co. Imaging Systems # Others see opportunities and 3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?" TEL: 508-659-2251 - FAX: 508-687-7265 # -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-