title: ''geometry::Point' failed because parameter 1 is not allowed to be null.' error when converting latlng to GEOM Point
body: <p>I am trying simply to convert Lat and Long Coordinates of Taxis to Geometry Points but when I do my query I get this error: ''geometry::Point' failed because parameter 1 is not allowed to be null.'
  The statement has been terminated.</p>
  
  <pre><code>UPDATE [dbo].[pdPoints] 
   SET  puGeom = GEOMETRY::Point(begintrip_lng, begintrip_lat, 4326),
        dfGeom = GEOMETRY::Point(dropoff_lng, dropoff_lat, 4326)
  </code></pre>
  
  <p>I have tried adding a this statement </p>
  
  <pre><code>WHERE 
      begintrip_lng is not null 
   or dropoff_lng is not null 
   or begintrip_lat is not null 
   or dropoff_lat is not null 
   or country_id is not null 
   or city_id is not null;
  </code></pre>
  
  <p>but I get the same result. :( Anyone who can help?</p>