loading script question

[marikabi]

Hi all,

is it possible to put an instruction in the loading script in order to change some information in the data?

For example, I have these columns MRC, CIRCUIT and COUNTRY, and I know I have an issue with the DB I am using and I would like to give this kind of instruction:

where the CIRCUIT name is ending with 5 and the COUNTRY is Spain , replace the value in the column MRC with 10.

Is it possible?

Many thanks in advance

[marikabi]

Hi,

I have used the formula proposed by Stefan and it works perfectly

I had to change two different MRC.

Now I will to apply the same structure to change some circuit info.. I will let you know if something will not work ..

Once again thank you!