RE: How to use SQL to update a substring?

In SQL, you must update the entire field.  In your case, the statement would
be as follows:
UPDATE FILEXXX SET FIELD1 = SUBSTR(FIELD1,1,5) || '2'

If the field length is longer than 6, you would need an additional SUBSTR
for the remaining length.

Why this limitation exists is for others than I to answer. 

Hope that helps.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
I can't seem to use SQL to update a SUBSTR of a field.

I'm trying to do:

UPDATE FILEXXX SET SUBSTR(FIELD1,6,1) = '2'
<clip>