View previous topic :: View next topic
|
Author |
Message |
mallikannasagaram
New User
Joined: 21 Feb 2006 Posts: 9 Location: india
|
|
|
|
Hi,
I need to REPLACE/UPDATE a partial string 'PQ' to 'QC' in a column (VARCHAR type) using SQL query. Please find following example for better understanding.
Example:
COLUMN VALUE UPADATE STRING
1000ABPQ 1000ABQC
XCPQJK XCQCJK
PQ QC
Please tell me the best way to do this...
Thanks & Regards,
Mallik |
|
Back to top |
|
|
mallikannasagaram
New User
Joined: 21 Feb 2006 Posts: 9 Location: india
|
|
|
|
Example:
COLUMN VALUE
1000ABPQ
XCPQJK
PQ
UPADATE STRING
1000ABQC
XCQCJK
QC |
|
Back to top |
|
|
Raphael Bacay
New User
Joined: 04 May 2007 Posts: 58 Location: Manila, Philippines
|
|
|
|
Hi!
I think you need to use COBOL with this.
You can SELECT all rows containing 'PQ' with a
COL = *PQ*.
Then you can Do a fetch of all rows containing columns
with PQ. Then you can do an INSPECT REPLACING ALL 'PQ' BY 'QC'.
Then you can UPDATE the replaced value into the table as you fetch
each row.
All in all you SELECT, FETCH, INSPECT, UPDATE each row that contains
the string 'PQ' to replace it with 'QC'.
Regards. |
|
Back to top |
|
|
|