Now with SQL Server 2025 length is optional you can:
https://learn.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql?view=sql-server-ver16
DECLARE @string varchar(10) = 'Y1223456883002' SELECT SUBSTRING(@string, LEN(@string)-2)