title: Select x and y coordinates by trimming unwanted characters
body: <p>I have a SQL table which contains a geometry column. This column takes the format of:</p>
  <p>POINT (323432.71888947 523412.81388917)</p>
  <p>I want to do a SELECT statement so I can return the X and Y coordinates WITHOUT any decimals. E.g. from the above I would want to return in two different X and Y columns:</p>
  <p>323432</p>
  <p>523412</p>
  <p>I am struggling to find the best way to do this. I guess using SUBSTRING is the way forwards but i'm not having much luck.</p>
  <p>This is using SQL Server.</p>