Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL Question: How to do an UPDATE to partially change a value?

SQL Question: How to do an UPDATE to partially change a value?

From: <robert.bowen_at_mubimedia.com>
Date: 2000/02/16
Message-ID: <88ekph$giq$1@nnrp1.deja.com>#1/1 






Hello all. I have a question - I have a date column with screwed up
data. Instead of '1999' in some rows I have '2099'. My own latent Y2K
bug. Anyway ... what's the easiest way to change these rows, just to
get rid of the '20' and replace it with '19' ?



I tried doing it using wildcards and old.date_col but I can't get it to
work ...



Anyone got a quick fix? I need a hit!



Thanks.


syg





Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Feb 16 2000 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US