SRID Conversion in SQL Server

[Stan]

Is there a function in SQL Server (similar to Postgres) or a formula to convert Lat/Lon (SRID 4269, as shown on the right side of the screenshot) into SRID 2253 STAsText (as shown on the left side of the image)?

The data on the right comes from a third-party app. I need to run a query to find the point that falls within certain boundaries (as shown in the table on the left) and update a specific field in the table via a trigger.

I would be grateful for any insights or ideas you can provide.

Thanks,
Stan

[ShannonShields]

You would need a function like ST_Transform, which unfortunately Microsoft does not provide for its Geometry data type. You won't be able to do this at the sql level.