Re: SQL SYNTAX

["Oludare" <oludare@xxxxxxxxxxxxx>]

Guys,

Thanks

----- Original Message -----
From: "Rolf Mittag" <rm@r-m-e-d-v.de>
To: <RPG400-L@midrange.com>
Sent: Tuesday, March 06, 2001 4:56 PM
Subject: Re: SQL SYNTAX


> the syntax is :
> substr(<fieldname>, <start>, <length>)
> where length may be omitted for the rightmost part
>
>          update qtemp/test
>                  set f1 = substr(f1, 1, 60) || '*' || substr(f1, 62)
>
> takes the first 60 bytes concatenates with "*" and then
> concatenates the rest from byte 62 for the field named "f1",
> i.e. it replaces byte 61 with "*".
>
> rgds Rolf
>
> ---------------------------
> Dipl.Inf.(FH) Rolf P Mittag
> Leipziger Str. 50
> D-69214 Eppelheim
> Fon: +49 (6221) 76 78 60
> Fax: +49 (6221) 76 80 26
> eMl: rm@r-m-e-d-v.de
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

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