SELECT
TeO_TreLp
,Teo_treNumer
,isnull((select StrValue
         from cdn.Split(isnull(teo_opis,''),':',0)
         where id =3),'') AS OPIS_Z_GIDEM
,isnull((select LEFT(teo_opis,4)) ,'') as ST
FROM Cdn.TReOPisy
WHERE
isnull((select LEFT(teo_opis,4)) ,'')= '__ŚT'