title: Need query in splitting the column value into three different columns
body: <p>I need help in a query in splitting a column value into three different columns. </p>
  
  <p>This is the column which I've in my database.</p>
  
  <pre><code>Asset
  ----------------------------------------------
  AP4INPU1:INPRD1HF@hkp04lp0605s-rs6000.hk.hsbc
  </code></pre>
  
  <p>I would like to split it as below</p>
  
  <pre><code>Asset                             InstanceName      ServerName
  ---------------------------------------------------------------
  AP4INPU1:INPRD1HF@hkp04lp0605s-   AP4INPU1          hkp04lp0605
  rs6000.hk.hsbc
  </code></pre>
  
  <p>Initially the server name is ending with 's' but I don't want 's' at the end in the new <code>ServerName</code> column.</p>
  
  <p>Regards,</p>
  
  <p>Bharath Vikas</p>