Converting Lat Lon to Geometry

[Highly_Frustrated]

Hi All bear with me if this is the wrong forum i have SQL code to use in VB for converting Lat Lon to Geography but need to convert to Geometry any help much appreciated.

 "UPDATE [dbo].[MyTable_Temp_Geo] SET [GEO_Location] = geography::STGeomFromText('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + CAST([Latitude] AS VARCHAR(20)) + ')', 4326)"

[Shaggy Hiker]

Not sure if it's in the right forum or not. What is happening with the code you have? Are you getting errors, if so, what are they?

[jmcilhinney]

If your issue is with the SQL rather than the VB code that executes the SQL then this should be in the Database Development forum. If you specify that that is the case, Shaggy can move the thread for you.