Update data to upper case in parent/child tables

Posted on 16th Feb 2014 07:03 pm by admin

Hi Gurus!

In production we have a product table and which is being reference by many tables making it parent child relationship. By mistake, we realized that last month some product were added in lower case and now we got a request to update all these product codes to upper case so that the existing code that use these tables have no impact. Appreciate if you can give some idea on how can I update the existing data in the parent table to upper case along with the child records?

Regards

Your Answer:

Login to answer

Other forums

SAP BCS. BPS
Hi all,

I am seeking reading note on the following in BW

BCS, BPS
ADVANCE

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896

Out of:
Binary String: xV4

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//