sty-geometry-data-type.md

title	STY (geometry Data Type)
description	STY provides the Y-coordinate property of a Point instance.
author	MladjoA
ms.author	mlandzic
ms.date	12/06/2024
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	STY_TSQL STY (geometry Data Type)
helpviewer_keywords	STY (geometry Data Type)
dev_langs	TSQL
monikerRange	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

STY (geometry Data Type)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

The Y-coordinate property of a Point instance.

Syntax

.STY  

Return Types

[!INCLUDEssNoVersion] type: float

CLR type: SqlDouble

Remarks

The value of this property will be null if the geometry instance is NOT a point. This property is read-only.

Examples

The following example creates a Point instance and uses STY to retrieve the Y-coordinate of the instance.

DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('POINT(3 8)', 0);  
SELECT @g.STY;  

Related content

STX (geometry Data Type)
STSrid (geometry Data Type)
OGC Methods on Geometry Instances