re: SQL SYNTAX

[<groyle@xxxxxxxx> (Gordon S. Royle)]

Try 

update bpcsusrf/gld77i set ftpdta = substr(ftpdta,1,13) || '7' || 
substr(ftpdta,15,??)  where ftpdta like 'ga%'  (?? is number of remaining 
chars) 

Your where clause could also be

where substr(ftpdta,1,2)  = 'ga' (if like complains)

Gord Royle
Cott Corporation
---------- Original Text ----------

From: oludare <oludare@ix.netcom.com>, on 3/6/01 3:12 PM:

Guys,

Is there something wrong with this SQL statement.  I am on OS400 V4R3M0.


update bpcsusrf/gld77i set substr(ftpdta,14,1) = '7'  where ftpdta like 
'ga%'                             

Dare





_______________________________________________________________

Cott - The Leader in Premium Retailer Brand Beverage Innovation. 
_______________________________________________________________
+---
| 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
+---