how do I insert a LONG varaible into a table

	Anybody knows how do I insert a value of a LONG column from
	one table into another? I tried running
	INSERT INTO table_1 (long_field1)
	SELECT long_field2
	FROM table_2;
	and got a 997 error "illegal use of a LONG type".

	I've been thinking of saving the data in a temp variable and
	then inserting this variablt into a table... Any other options?

TIA

• *
• In case of nuclear war, ignore this message *
• *

  ---