5 Replies Latest reply: Jan 11, 2011 1:40 PM by John Witherspoon RSS

    Script little help

    Nikos Antonopoulos

      Hello all,

       

      I'm a newbie so please forgive me for this question if it is too easy.

      I have already made the my SQL script and the pivot tables, the charts everything. The only problem I have and I do not want to change the SQL script is the following:

      My lines have some values like this.

      peter, student, patras
      tom, student, athens
      john, worker, mykonos

      I want every time that I get the value 'athens' to transform it to 'central'. How can I do this in the script?

      Thanks!!!