Substring with easy on SQL Server

[Costas]

SELECT CAST('test-' AS VARCHAR(1))