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