Re: How do I update part of a field's value in SQL

From: <christianboivin_at_my-deja.com>
Date: Tue, 09 Jan 2001 17:48:06 GMT
Message-ID: <93fisk$ob$1@nnrp1.deja.com>

Hi

You can try this

update [table] a
set binnum = (select 'MD06' || substr(binnum,5,3)

             from [table] b
             where a.rowid = b.rowid)

where substr(binnum,1,4) = 'MC14';

Hope it help

Chris

In article <93fbog$qk6$1_at_nnrp1.deja.com>,   dthomas5_at_my-deja.com wrote:
> In a table I wish to update I have a field named BINNUM which refers
 to the
> location an item is stored in a stockroom. BINNUM is seven (7)
 characters
> long and is represented by the following example: MC1402A. The MC
 refers to
> the aisle the cabinet is located, the 14 refers to the cabinet number
 (the
> 14th one down the aisle in this case) 02 refers to the drawer number
 (second
> drawer from the top here) and A for the location within that drawer.
>
> We have just finished rearranging the stockroom, so unfortunately the
> cabinets are no longer in the same place, requiring them to be
 renumbered
> physically and within the application. So for example MC1402A may now
 be
> MD0602A (drawer number and space in drawer remain the same)---I need
 to be
> able to change just the first four characters to a new value so that
 anything
> that was MC14*** is now MD06*** for the entire contents of the
 cabinet. I am
> not certain how this is done as an update using a wildcard--or even
 if that
> is the right approach. I know that in DOS I can rename a series of
 files and
> maintain part of the original name using a wildcard but not sure here.
>
> Thanks for the help.
>
> David Thomas
>
> david_thomas_at_udlp.com
> dthomas5_at_home.com
> jvthomas_at_welchlink.welch.jhu.edu
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 09 2001 - 11:48:06 CST