Select ROUND(SP_GEOMETRY.STX, 0) As X, ROUND(SP_GEOMETRY.STY, 0) As Y
   From dbo.MY_TABLE;

Select 'POINT('
      + Cast(ROUND(SP_GEOMETRY.STX, 0) As VarChar)
      + ' '
      + Cast(ROUND(SP_GEOMETRY.STY, 0) As VarChar)
      + ')' As WKT
   From dbo.MY_TABLE;

cast(SUBSTRING(M.GEOMETRY.STCentroid().ToString(),8,6)as int) AS EASTING

cast(SUBSTRING(M.GEOMETRY.STCentroid().ToString(),CHARINDEX(' ',M.GEOMETRY.STCentroid().ToString(),1+CHARINDEX(' ',M.GEOMETRY.STCentroid().ToString(),0)),6)as int) AS NORTHING