title: I have a mobile column having data in the format 91-98-91254*** I want to display the data in 3 separate columns separeted by " - "
body: <p>The query removes the " - " but then after that i want to display each set in 3 different columns`enter code here</p>
  
  <pre><code>SELECT SUBSTRING(RIGHT(REPLACE(mobile,'-',''),10),1,3) + ' ' +
         SUBSTRING(RIGHT(REPLACE(mobile,'-',''),10),4,3) + ' ' +
         SUBSTRING(RIGHT(REPLACE(mobile,'-',''),10),7,4)
  FROM candidate_jitendra
  </code></pre>