Here is a thought: Create a view that takes the number of characters needed from the BLOB column

SELECT Col1, Col2, Col3, (SGET(BlobColumn,100,1)), Col4
and so forth.

Albert

Luc Delcoigne wrote:
Hi,
I have to generate an ascii fixed field file. this works fine with the indications Razzak gave me yesterday, as far as 'normal' columns and fields are concerned. however, now I need to read in the contents of a text saved as a Varbit blob as text into the fixed field text file. How do I do this ?? Grtz Luc Delcoigne


Reply via email to