title: Parsing Geometry to Latitude, Longitude is failing
body: <p>I have a table of locations with Latitude and Longitude values. </p>
  
  <pre><code>Loc_Nm || geocode_latitude || geocode_longitude
     A   ||    43.43044      ||    -80.0910793
     W   ||    43.9114523    ||    -80.0911329
     X   ||    43.9209011    ||    -80.091323
     Y   ||    43.9083203    ||    -80.0913039
     Z   ||    43.914577     ||    -80.091198
  </code></pre>
  
  <p>I have a geometry table with area names (shown below) which has been converted from Shapefile through ogr2ogr. </p>
  
  <p><a href="https://i.stack.imgur.com/5BER8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5BER8.png" alt="Table2"></a>
  I need to group the Table1 locations into specific regions as per Table2. I am using a query utilizing below-mentioned snippet.</p>
  
  <pre><code>select * from MyDB.dbo.Spatial_Data s, MyDB.dbo.geocodes_raw g 
  where ogr_geometry.STContains(geometry::Parse('POINT(' + CAST(g.geocode_longitude AS VARCHAR(20)) + ' ' + CAST(g.geocode_latitude AS VARCHAR(20)) + ')'))=1;
  </code></pre>
  
  <p>But, it is failing with below-given error.</p>
  
  <pre><code>Msg 6522, Level 16, State 1, Line 62
  A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": 
  System.FormatException: 24141: A number is expected at position 7 of the input. The input has ).
  System.FormatException: 
     at Microsoft.SqlServer.Types.WellKnownTextReader.RecognizeDouble()
     at Microsoft.SqlServer.Types.WellKnownTextReader.ParsePointText(Boolean parseParentheses)
     at Microsoft.SqlServer.Types.WellKnownTextReader.ParseTaggedText(OpenGisType type)
     at Microsoft.SqlServer.Types.WellKnownTextReader.Read(OpenGisType type, Int32 srid)
     at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
     at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
  .
  </code></pre>
  
  <p>What is possibly wrong here?</p>