db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Reginald Johnson" <reginald.john...@gmail.com>
Subject Update Substring of a field
Date Sun, 30 Mar 2008 04:48:33 GMT
Is it possible to update the substring of a field?  I'm trying to do
something like this:

UPDATE tblIntervals SET SessionMouseID = 'ggg',  substr(SessionID, 0, 3) =
'ggg' WHERE SessionMouseID = 'bbb'

Mime
View raw message