Issue On Values when separate it to value and text?

Transact-SQL
,
8

I don't have sql sever 2016 i have SQL server 2012