CREATE TABLE varchar_tab1 (a int, b VARCHAR (60000)); INSERT INTO varchar_tab1 VALUES (1001, 'Point(10 20 30)'); CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry); INSERT INTO sample_shapes SELECT a, SYSSPATIAL.ST_GeomFromText(b) FROM varchar_tab1; SELECT * FROM sample_shapes;