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
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'
>
>

Mime
View raw message