Shape.Area and Shape.len via ODBC

[gismoe]

I need to use some attributes from a sde-feature class in a EXCEL-Query.
All fields are show but Shape.Area and Shape.len are missing.

These field are not shown in the SQL Managment Studio so i think that this attribute are
stored in a different place.

So maybe i can create a Database View.

But i don't now where?!

[dancheng]

Hi all,

Yes, when I tried something like >0 or between value range, it works, thanks for pointing out the precision issue .

This raised up another question I have:

What if I want to know if the shape.length() column contain certain numbers (e.g., 234). For strings, I can do fieldname Like '%234%',however, for numbers, it seems like no such function is available....

Any thoughts would be appreciated, thanks!

Dan

[VinceAngelo]

No, there's no standard wildcard operator for numeric values.  You'd need to play
with modulus or casting functions, but that's really more appropriate for the RDBMS
vendor's forums.

- V

[dancheng]

Got it, thanks for the help!

No, there's no standard wildcard operator for numeric values.  You'd need to play
with modulus or casting functions, but that's really more appropriate for the RDBMS
vendor's forums.

- V