Geography data type error

[G12Consult]

I have a field in a table with the geography data type.

I can write to the field using a lat & long reference which gives me a value of: 0xE6100000010CF4F8BD5D7F063CC059349D9D0C2A6340

When I try to extract the lat out of that field using

SELECT GEOLOCATION.LONG

, I receive the error:

Could not find property or field 'long' for type 'Microsoft.SqlServer.Types.SqlGeography' in assembly 'Microsoft.SqlServer.Types'.

I thought this should work?

 

[Andrzejek]

Have you tried:

Select	GEOLOCATION.Longitude
From	YourTable

Sample from here


---- Andy

There is a great need for a sarcasm font.

 

[G12Consult]

Yeah tried that. still doesn't work.

 

[G12Consult]

This worked though

SELECT geolocation.Lat as Lat, geolocation.Long as Lon from INVESTOR.PROPERTIES

I read something about case sensitivity regarding spatial data