On Fri, 12 Nov 2004 08:42:31 -0600, Rob Smith <rob.smith at thermon.com> wrote: > By any slim slight chance of hope does anyone know or have an INSERT to > UPDATE converter for SQL statements? > > I've have about 250 cut and pastes to do, and trying to save some sanity, You can usually achieve this sort of automation using a macro or regex in a powerful text editor such as Ultraedit. Post an example of the sort of conversion you want to acheive and we will be able to help you more specifically. Tim -- http://elaborate.sourceforge.net/ - Free PHP/MySQL wiki engine http://www.apatheticgenius.com/