Re: SQL - how to update first byte of field

["Joe Pluta " <joepluta@xxxxxxxxxxxxxxxxx>]

Old trick:

update filename set item = '6' + substr(item, 1, 5)

Joe

P.S.  I'm braindead today, and can't remember if "+" works for string 
concatenation.

---------- Original Message ----------------------------------
From: StoneJ@GourmetAward.com
Reply-To: MIDRANGE-L@midrange.com
Date: Mon, 7 May 2001 11:13:55 -0400 

>Using SQL, can I modify the first byte of an alpha field without affecting
the rest of the field?

Something like:

runsql 'update FILENAME set substr(item,1,1) = ''6''


I cannot get past the syntax errors with this command.


Thanks!
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---