Hi, Derby does not have a built in function that would enable you to do that,
but I think it should be simple enough to write one using the instructions and the
samples provided here http://wiki.apache.org/db-derby/DerbySQLroutines Narayanan Reginald Johnson wrote:
Hello,Does Derby have a built in function that would allow me to do an SQL query to update a substring, something like this:UPDATE TABLE1 SET SUBSTRING(FieldName, original-substring, new-substring) WHERE FIELD1 = 'moose'
