title: sql get get first character, trim till period, then remaining characters
body: <p>I have a column of names and I need to select the first character till a period then get the remaining characters.</p>
  
  <p>Example</p>
  
  <p>Source Column name              Desired output</p>
  
  <pre><code>bob.smith                       bsmith
  mary.alice                      malice
  bill.gates                      bgates
  </code></pre>