SELECT
    _ParentIDRRef, 
    CAST(_ParentIDRRef AS NVARCHAR(MAX)) AS cast1, 
    CAST(_ParentIDRRef AS VARCHAR(MAX)) COLLATE Cyrillic_General_CI_AS AS cast2, 
    CONVERT(VARCHAR(MAX), _ParentIDRRef) AS convert1 
FROM
    _Reference10339

This column in application displayed as Cyrillic text. I am trying to get this column text in a T-SQL statement.

I have tried several statements, but did not succeed yet.