Convert sql_variant to varchar to select left 2
Try explicitly converting the sql_variant column to varchar before applying the LEFT function.  The following simple example worked for me.

Declare @V sql_variant
set @v = '13.0.5026.0'
select left(convert(varchar(max),@v),2)




| (No column name) |
|------------------|
| 13               |