7 Replies Latest reply on Sep 26, 2018 7:30 AM by igreguri

    PI SQL Commander syntax - how to cut part of string

    igreguri

      I have lot of tags which look like...

      BOSTON:PHILADELPHIA

       

      I want to get two columns as a result, left and right of the sign :

      Left                        Right

      BOSTON               PHILADELPHIA

       

      How to do it with PI SQL Commander syntax?

      Regards,

      Igor