db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narayanan <V.Naraya...@Sun.COM>
Subject Re: Updating a Substring in a Field
Date Mon, 31 Mar 2008 04:24:11 GMT

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



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'

View raw message