| Subject | Re: [firebird-support] newb: help with an update statement |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2004-02-24T12:12:05Z |
On 21 Feb 2004 at 9:22, Helen Borrie wrote:
SY, Dimitry Sibiryakov.
>Use the internal SUBSTRING function. Now, let's assume PARTNUM is aAFAIK, SUBSTRING(PARTNUM FROM 3) works too.
>varchar(20) - change your numbers to suit.
>
>update PARTSTABLE
> set PARTNUM = SUBSTRING(PARTNUM FROM 3 FOR 18)
SY, Dimitry Sibiryakov.