AnsweredAssumed Answered

PI SQL Commander syntax - how to cut part of string

Question asked by igreguri Champion on Sep 25, 2018
Latest reply on Sep 26, 2018 by 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

Outcomes