I want to thank Reggie and Elvis for supplying the winning UPDATE SQL syntax to solve my problem. Here is an example of the SQL:

update dodom1/dictionary
set S_WORD = substr(S_WORD,1,2)||'O'|| substr(S_WORD,4)
where S_WORD = 'Rojo'

I was sure there was a way to use SUBSTR for this kind of thing and there is.

Thanks again,

Dave Odom

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].