How can I use a WKT as an input to a function?

Question

I have the following where clause in a t-sql statement: ``` where a.CELL_GEOM.STIntersects( STGeomFromText('POLYGON((-25.43623984375 44.257784519021, 21.62918984375 44.257784519021, 21.62918984375 60.752403080295, -25.43623984375 60.752403080295, -25.43623984375 44.257784519021))', 4326)) = 'true' ``` The line reports the error: ``` 'STGeomFromText' is not a recognized built-in function name. ``` How can I use the well known text value shown in this function? Am I just using incorrect syntax with the STGeomFromText as that is the only example I have seen.

Accepted Answer

Try prefixing the name of the function with `geometry::` like in the documentation?

E.g. : `geometry::STGeomFromText( ...`

Link to documentation

How can I use a WKT as an input to a function?

Solution

Problem