Insert into table with TEXT column

Howdy, Was hoping someone out there knows how to deal with doing inserts/updates into a table that has one of the columns defined as type `text`. ie: insert into $TABLE values ("...","...",..); where values is a comma separated list of values to be inserted, in the order that the columns appear when you do an 'info columns for $TABLE'. My table is defined as : Column name Type Nulls note_id char(20) no note_object char(10) no note_text text yes originator_name char(20) no datetime_stamp datetime year to fraction(5) no If I try to do an insert for the columns other than the text field, I think the insert will fail due to the values being out of sequence. Should the text item be the last one defined for the table? How do I manage inserts and updates for the text item? Any ideas? Thanks, Kathy -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | Kathy Baughman | E-Mail: kathy@mothra.rose.hp.com | | Production Automation Solution Eng. | | | Solutions Mfg and Dist Operation | Telnet: 1-785-5768 | | 8000 Foothills Blvd. | Telephone: (916) 785-5768 | | Roseville, California 95747-5586 | Fax: (916) (916) 785-5663 | | Mailstop: 5586 | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~