OK i have a string that is longer than 2000 chars. Oracle won't allow more than 2000 chars on an insert. What is the SQL command to add a substring to the end of what is already in the db? For those interested here is the code? NOTe: update is where i'm getting the problems <cftransaction> <cfloop index="i" from="1" to="#variables.contentLen#" step="2000"> <cfset variables.content = Mid(form.content, i, 2000)> <cfif i EQ 1> <cfquery name="insertArticle" datasource="#application.dsn#"> INSERT INTO PressRelease (Header, Content, PressReleaseDate) VALUES ('#form.header#', '#variables.Content#', TO_DATE('#form.PressReleaseDate#', 'mm/dd/yyyy')) </cfquery> <cfelse> <cfquery name="update" datasource="#application.dsn#"> UPDATE PressRelease SET Content = Content + '#variables.content#' <----THIS IS WHERE THE PROBLEM IS WHERE sq_PressRelease.currval </cfquery> </cfif> </cfloop> </cftransaction> ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]