title: SQL Query for splitting the strings into rows and columns
body: <p>I have a string in following format:</p>
  
  <pre><code>A:B:C;J:K;P:L:J;
  </code></pre>
  
  <p>I want to split the string after colon(:) and start a new row after semicolon(;). 
  Can anyone help me with a query. </p>
  
  <p>Output Example: </p>
  
  <pre><code>A B C
  
  J K
  
  P L J
  </code></pre>