RE: SQL statement help

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

On Wednesday, May 13, 1998 3:58 AM, Marco Stanghellini 
[SMTP:mstanga@tin.it] wrote:
> Hi I'm from Italy,
> First of all sorry for my bad English.
> I'm trying improving my SQL and now I really need help in a UPDATE
> statement.
> I have a file with a character FIELD called SERIAL (p.e. "DB90999"), now
> I
> need to change all the field that have the first two character = "DB"
> with
> "AB" leaving all the rest as is.

Marco,
  Buongiorno!

One way to do this is to substring the part of FIELD that
you want to keep and concatenate that to the literal value
that you want to replace:

update FILENAME set FIELD='AB' concat substr(FIELD,3,5)
where substr(FIELD,1,2)='DB'

hope this helps...

Buck Calabro
Commsoft, Albany, NY
mailto:mcalabro@commsoft.net

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---